private bool SelectAndInsertExclusive(string mitsumoriNo) { //DeleteExclusive(); //排他Tableに該当番号が存在するとError //[D_Exclusive] Exclusive_BL ebl = new Exclusive_BL(); D_Exclusive_Entity dee = new D_Exclusive_Entity { DataKBN = (int)Exclusive_BL.DataKbn.Mitsumori, Number = mitsumoriNo, Program = this.InProgramID, Operator = this.InOperatorCD, PC = this.InPcID }; DataTable dt = ebl.D_Exclusive_Select(dee); if (dt.Rows.Count > 0) { bbl.ShowMessage("S004", dt.Rows[0]["Program"].ToString(), dt.Rows[0]["Operator"].ToString()); //detailControls[(int)EIndex.MitsumoriNO].Focus(); return(false); } else { bool ret = ebl.D_Exclusive_Insert(dee); mOldMitsumoriNo = mitsumoriNo; return(ret); } }
public bool D_Exclusive_Insert(D_Exclusive_Entity dee) { string sp = "D_Exclusive_Insert"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@DataKBN", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dee.DataKBN.ToString() } }, { "@Number", new ValuePair { value1 = SqlDbType.VarChar, value2 = dee.Number } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = dee.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = dee.Program } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = dee.PC } }, }; UseTransaction = true; return(InsertUpdateDeleteData(dic, sp)); }
/// <summary> /// </summary> /// <param name="dme"></param> /// <param name="operationMode"></param> /// <param name="operatorNm"></param> /// <param name="pc"></param> /// <returns></returns> public bool D_Exclusive_Exec(D_Exclusive_Entity dme, DataTable dt, short operationMode, string operatorNm, string pc) { string sp = "PRC_MitsumoriNyuuryoku"; command = new SqlCommand(sp, GetConnection()); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = 0; command.Parameters.Add("@OperateMode", SqlDbType.TinyInt).Value = operationMode; //command.Parameters.Add("@GeneralRate", SqlDbType.Decimal).Value = dme.GeneralRate; //command.Parameters.Add("@MemberRate", SqlDbType.Decimal).Value = dme.MemberRate; //command.Parameters.Add("@ClientRate", SqlDbType.Decimal).Value = dme.ClientRate; //command.Parameters.Add("@SaleRate", SqlDbType.Decimal).Value = dme.SaleRate; //command.Parameters.Add("@WebRate", SqlDbType.Decimal).Value = dme.WebRate; command.Parameters.Add("@Table", SqlDbType.Structured).Value = dt; command.Parameters.Add("@DeleteFlg", SqlDbType.TinyInt).Value = dme.DeleteFlg; command.Parameters.Add("@UsedFlg", SqlDbType.TinyInt).Value = dme.UsedFlg; command.Parameters.Add("@Operator", SqlDbType.VarChar).Value = operatorNm; command.Parameters.Add("@PC", SqlDbType.VarChar).Value = pc; string outPutParam = ""; UseTransaction = true; return(InsertUpdateDeleteData(sp, ref outPutParam)); }
/// <summary> /// 排他処理データを削除する /// </summary> private void DeleteExclusive(DataTable dtForUpdate = null) { if (mOldInstructionNO == "" && dtForUpdate == null) { return; } Exclusive_BL ebl = new Exclusive_BL(); if (dtForUpdate != null) { foreach (DataRow dr in dtForUpdate.Rows) { D_Exclusive_Entity de = new D_Exclusive_Entity(); de.DataKBN = (int)Exclusive_BL.DataKbn.SyukkaShiji; de.Number = dr["no"].ToString(); ebl.D_Exclusive_Delete(de); } return; } D_Exclusive_Entity dee = new D_Exclusive_Entity { DataKBN = (int)Exclusive_BL.DataKbn.Mitsumori, Number = mOldInstructionNO, }; bool ret = ebl.D_Exclusive_Delete(dee); mOldInstructionNO = ""; }
private bool SelectAndInsertExclusive(string InstructionNO) { DeleteExclusive(); //排他Tableに該当番号が存在するとError //[D_Exclusive] Exclusive_BL ebl = new Exclusive_BL(); D_Exclusive_Entity dee = new D_Exclusive_Entity { DataKBN = (int)Exclusive_BL.DataKbn.SyukkaShiji, Number = InstructionNO, Program = this.InProgramID, Operator = this.InOperatorCD, PC = this.InPcID }; DataTable dt = ebl.D_Exclusive_Select(dee); if (dt.Rows.Count > 0) { bbl.ShowMessage("S004", dt.Rows[0]["Program"].ToString(), dt.Rows[0]["Operator"].ToString()); return(false); } else { bool ret = ebl.D_Exclusive_Insert(dee); mOldInstructionNO = InstructionNO; return(ret); } }
/// <summary> /// 排他処理データを削除する /// </summary> private void DeleteExclusive(DataTable dtForUpdate = null) { if (mOldBillingNo == "" && dtForUpdate == null) { return; } Exclusive_BL ebl = new Exclusive_BL(); if (dtForUpdate != null) { foreach (DataRow dr in dtForUpdate.Rows) { D_Exclusive_Entity de = new D_Exclusive_Entity(); de.DataKBN = (int)Exclusive_BL.DataKbn.Seikyu; de.Number = dr["no"].ToString(); ebl.D_Exclusive_Delete(de); } return; } D_Exclusive_Entity dee = new D_Exclusive_Entity { DataKBN = (int)Exclusive_BL.DataKbn.Seikyu, Number = mOldBillingNo, }; bool ret = ebl.D_Exclusive_Delete(dee); mOldBillingNo = ""; }
/// <summary> /// </summary> public DataTable D_Exclusive_SelectData(D_Exclusive_Entity mie, short operationMode) { string sp = "D_Exclusive_SelectData"; //command.Parameters.Add("@SyoKBN", SqlDbType.TinyInt).Value = mie.SyoKBN; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@OperateMode", new ValuePair { value1 = SqlDbType.TinyInt, value2 = operationMode.ToString() } }, //{ "@MitsumoriNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = mie.MitsumoriNO } }, }; return(SelectData(dic, sp)); }
public DataTable D_Exclusive_Select(D_Exclusive_Entity dee) { string sp = "D_Exclusive_Select"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@DataKBN", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dee.DataKBN.ToString() } }, { "@Number", new ValuePair { value1 = SqlDbType.VarChar, value2 = dee.Number } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 排他処理データを削除する /// </summary> private void DeleteExclusive(DataTable dtForUpdate = null) { if (dtForUpdate == null) { return; } Exclusive_BL ebl = new Exclusive_BL(); if (dtForUpdate != null) { foreach (DataRow dr in dtForUpdate.Rows) { D_Exclusive_Entity de = new D_Exclusive_Entity(); de.DataKBN = (int)Exclusive_BL.DataKbn.Shiire; de.Number = dr["no"].ToString(); ebl.D_Exclusive_Delete(de); } return; } }
public bool D_Exclusive_Delete(D_Exclusive_Entity dee) { return(mdl.D_Exclusive_Delete(dee)); }
public bool D_Exclusive_Insert(D_Exclusive_Entity dee) { return(mdl.D_Exclusive_Insert(dee)); }
public DataTable D_Exclusive_Select(D_Exclusive_Entity dee) { DataTable dt = mdl.D_Exclusive_Select(dee); return(dt); }