public bool HaitaSakujo_ClearExclusive(HaitaSakujoEntity obj)
{
try
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
var parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@xml", SqlDbType.Xml)
{
Value = obj.xml
};
parameters[1] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.ProgramID
};
parameters[3] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = obj.InsertOperator
};
return(ckmdl.InsertUpdateDeleteData("HaitaSakujo_ClearExclusive", GetConnectionString(), parameters) == "true");
}
catch (Exception ex)
{
var msg = ex.Message;
}
return(false);
}
private void btnClearExclusive()
{
//if (!IsCheckExist())
//{
// bll.ShowMessage("E257");
// F12.Focus();
// return;
//}
var dt = new DataTable();
// dt = (gvHaitaSakujo.DataSource as DataTable).Select("Target = 1").CopyToDataTable();
dt = GetRes();
HaitaSakujoBL bl = new HaitaSakujoBL();
HaitaSakujoEntity obj = new HaitaSakujoEntity();
obj.xml = DataTableToXml(dt);
dt.Rows.Clear();
obj.PC = PCID;
obj.ProgramID = ProgramID;
obj.InsertOperator = OperatorCD;
if (bl.HaitaSakujo_ClearExclusive(obj))
{
bll.ShowMessage("I101");
try
{
cf.Clear(PanelDetail);
F10.PerformClick();
}
catch { }
}
}
private void btnDisplay()
{
HaitaSakujoBL bl = new HaitaSakujoBL();
HaitaSakujoEntity obj = new HaitaSakujoEntity();
obj.ChangeDate = txt_date.Text;
obj.DataKBN = txt_dataPartition.Text;
obj.InputPerson = txt_InputPerson.Text;
obj.Program = txt_Program.Text;
obj.OperateDataTime1 = txt_Time1.Text + txt_HM1.Text;
obj.OperateDataTime2 = txt_Time2.Text + txt_HM2.Text;
//obj.OperateDataTimeHM1 = txt_HM1.Text;
//obj.OperateDataTimeHM2 = txt_HM2.Text;
DataTable dt = dtr = bl.HaitaSakujo_Display(obj);
gvHaitaSakujo.DataSource = dt;
}
public DataTable HaitaSakujo_Display(HaitaSakujoEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
parameters[1] = new SqlParameter("@DataKBN", SqlDbType.VarChar)
{
Value = obj.DataKBN
};
parameters[2] = new SqlParameter("@InputPerson", SqlDbType.VarChar)
{
Value = obj.InputPerson
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.Program
};
parameters[4] = new SqlParameter("@OperateDataTime1", SqlDbType.VarChar)
{
Value = obj.OperateDataTime1
};
parameters[5] = new SqlParameter("@OperateDataTime2", SqlDbType.VarChar)
{
Value = obj.OperateDataTime2
};
//parameters[6] = new SqlParameter("@OperateDataTimeHM1", SqlDbType.VarChar) { Value = obj.OperateDataTimeHM1 };
//parameters[7] = new SqlParameter("@OperateDataTimeHM2", SqlDbType.VarChar) { Value = obj.OperateDataTimeHM2 };
DataTable dt = ckmdl.SelectDatatable("HaitaSakujo_Display", GetConnectionString(), parameters);
return(dt);
}
