public void dg_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dg.EditItemIndex=-1;
dg.DataSource=dst;
dg.DataBind();
}
public void dg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string code=e.Item.Cells[1].Text;
SqlParameter[] ArrParam={ new SqlParameter("@code",SqlDbType.VarChar) };
ArrParam[0].Value=code;
DB.db db=new DB.db();
try
{
db.ExecuteSql("DelLabCatalog",ArrParam);
}
catch(Exception Err)
{
Response.Write("<script language='javascript'>alert(/"ハセンノセウハァーワ//n"+Err.Message+"/")</script>");
}
myDataBind();
if(dst.Tables[0].Rows.Count<=0)
{
dg.Visible=false;
string js=@"<script language='javascript'>MessageNoData('myDiv');";
js+="</script>";
if(!this.IsStartupScriptRegistered("Startup"))
this.RegisterStartupScript("Startup", js);
return;
}
//dg.DataSource=dst;
dg.DataBind();
}
public void dg_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dg.EditItemIndex=e.Item.ItemIndex;
myDataBind();
dg.DataBind();
string js=@"<script language='javascript'>function EditDgData()";
js+="{ ";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').maxLength=10;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').size=6;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').style.color='#00836A';";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').focus();";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').maxLength=20;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').size=35;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').style.color='#00836A';";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').maxlength=10;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').size=6;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').style.color='#00836A';";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').maxlength=15;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').size=15;";
js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').style.color='#00836A';";
js+="}";
js+="setTimeout(EditDgData,1);</script>";
if (!IsClientScriptBlockRegistered("clientScript"))
{
RegisterClientScriptBlock("clientScript", js);
}
}
public void dg_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string code=e.Item.Cells[1].Text.Trim();
TextBox txtxcode=(TextBox)e.Item.Cells[2].Controls[0] ;
string xcode=txtxcode.Text.Trim();
TextBox txtname=(TextBox)e.Item.Cells[3].Controls[0];
string name=txtname.Text.Trim();
TextBox txtunit=(TextBox)e.Item.Cells[4].Controls[0];
string unit=txtunit.Text.Trim();
TextBox txtgg=(TextBox)e.Item.Cells[5].Controls[0];
string gg=txtgg.Text.Trim();
SqlParameter[] arr={ new SqlParameter("@code",SqlDbType.VarChar),
new SqlParameter("@xcode",SqlDbType.VarChar),
new SqlParameter("@name",SqlDbType.VarChar),
new SqlParameter("@gg",SqlDbType.VarChar),
new SqlParameter("@unit",SqlDbType.VarChar)
};
arr[0].Value=code;
arr[1].Value=xcode;
arr[2].Value=name;
arr[3].Value=unit;
arr[4].Value=gg;
updateData("UpdataLabInf",arr);
dg.EditItemIndex=-1;
myDataBind();
dg.DataBind();
}
private void dg_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dg.CurrentPageIndex=e.NewPageIndex;
myDataBind();
dg.DataBind();
}
private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item.ItemIndex != -1)
{
LinkButton del = (LinkButton)e.Item.Cells[e.Item.Cells.Count-1].Controls[0];
del.Attributes["onclick"] = "return confirm('ネキカィメェノセウクテフヌツシツソ');";
}
}