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); }