public DataTable GetStaff(StaffEntity staffEntity) { staffEntity.Sqlprms = new SqlParameter[1]; staffEntity.Sqlprms[0] = new SqlParameter("@MessageID", staffEntity.StaffCD); DataTable dtStaff = ckmdl.SelectDatatable("M_Staff_Select", GetConnectionString(), staffEntity.Sqlprms); return(dtStaff); }
public DataTable ShukkasiziNyuuryoku_Data_Select(ShukkaSiziNyuuryokuEntity se, int type) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[5]; //parameters[0] = new SqlParameter("@ShippingDate", SqlDbType.VarChar) { Value = se.ShippingDate }; parameters[0] = new SqlParameter("@ShippingNo", SqlDbType.VarChar) { Value = se.ShippinNo }; parameters[1] = new SqlParameter("@Operator", SqlDbType.VarChar) { Value = se.OperatorCD }; parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = se.ProgramID }; parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = se.PC }; parameters[4] = new SqlParameter("@Type", SqlDbType.TinyInt) { Value = type }; DataTable dt = ckmdl.SelectDatatable("ShukkasiziNyuuryoku_Data_Select", GetConnectionString(), parameters); return(dt); }
public DataTable JuchuuTorikomi_Delete(string sp_name, string Xml, string DenpyouNO, JuchuuTorikomiEntity entity) { CKMDL ckmdl = new CKMDL(); ckmdl.UseTran = true; var parameters = new SqlParameter[5]; parameters[0] = new SqlParameter("@XML", SqlDbType.Xml) { Value = Xml }; parameters[1] = new SqlParameter("@DenyouNO", SqlDbType.VarChar) { Value = DenpyouNO }; parameters[2] = new SqlParameter("@ProgramID", SqlDbType.VarChar) { Value = entity.ProgramID }; parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = entity.PC }; parameters[4] = new SqlParameter("@OperatorCD", SqlDbType.VarChar) { Value = entity.OperatorCD }; return(ckmdl.SelectDatatable(sp_name, GetConnectionString(), parameters)); }
public DataTable Kouriten_Select_Check(string cd, string changeDate, string errorType, [Optional] string cd1) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@KouritenCD", SqlDbType.VarChar) { Value = cd }; parameters[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = changeDate }; parameters[2] = new SqlParameter("@Errortype", SqlDbType.VarChar) { Value = errorType }; parameters[3] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = cd1 }; DataTable dt = ckmdl.SelectDatatable("Kouriten_Select_Check", GetConnectionString(), parameters); return(dt); }
public DataTable ShukkaTorikomi_Check(string CD, string changeDate, string error_type, string CD_Type) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@CD", SqlDbType.VarChar) { Value = CD }; parameters[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = changeDate }; parameters[2] = new SqlParameter("@Errortype", SqlDbType.VarChar) { Value = error_type }; parameters[3] = new SqlParameter("@CD_Type", SqlDbType.VarChar) { Value = CD_Type }; DataTable dt = ckmdl.SelectDatatable("ShukkaTorikomi_Check", GetConnectionString(), parameters); return(dt); }
public DataTable Siiresaki_Search(SiiresakiEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@SiiresakiCD1", SqlDbType.VarChar) { Value = obj.SiiresakiCD }; parameters[1] = new SqlParameter("@SiiresakiCD2", SqlDbType.VarChar) { Value = obj.SiiresakiRyakuName }; parameters[2] = new SqlParameter("@SiiresakiName", SqlDbType.VarChar) { Value = obj.SiiresakiName }; parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; parameters[4] = new SqlParameter("@RadioCheck", SqlDbType.VarChar) { Value = obj.Remarks }; parameters[5] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; DataTable dt = ckmdl.SelectDatatable("Siiresaki_Search", GetConnectionString(), parameters); return(dt); }
public DataTable Staff_Search(MasterTourokuStaff obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@StaffCD1", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[1] = new SqlParameter("@StaffCD2", SqlDbType.VarChar) { Value = obj.Passward }; parameters[2] = new SqlParameter("@StaffName", SqlDbType.VarChar) { Value = obj.StaffName }; parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; parameters[4] = new SqlParameter("@RadioCheck", SqlDbType.VarChar) { Value = obj.Remarks }; parameters[5] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; DataTable dt = ckmdl.SelectDatatable("Staff_Search", GetConnectionString(), parameters); return(dt); }
public DataTable IdouNyuuryoku_Select_Check(string IdouNo, string juchuuDate, string err, [Optional] string KanriNo) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@IdouNo", SqlDbType.VarChar) { Value = IdouNo }; parameters[1] = new SqlParameter("@Date", SqlDbType.VarChar) { Value = juchuuDate }; parameters[2] = new SqlParameter("@ErrorType", SqlDbType.VarChar) { Value = err }; parameters[3] = new SqlParameter("@KanriNo", SqlDbType.VarChar) { Value = KanriNo }; DataTable dt = ckmdl.SelectDatatable("IdouNyuuryoku_Select_Check", GetConnectionString(), parameters); return(dt); }
public DataTable Souko_Search(SoukoEntity soukoEntity) { CKMDL ckmdl = new CKMDL(); soukoEntity.Sqlprms = new SqlParameter[4]; soukoEntity.Sqlprms[0] = new SqlParameter("@SoukoCD1", SqlDbType.VarChar) { Value = soukoEntity.SoukoCD }; soukoEntity.Sqlprms[1] = new SqlParameter("@SoukoCD2", SqlDbType.VarChar) { Value = soukoEntity.Tel11 }; soukoEntity.Sqlprms[2] = new SqlParameter("@SoukoName", SqlDbType.VarChar) { Value = soukoEntity.SoukoName }; soukoEntity.Sqlprms[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = soukoEntity.KanaName }; DataTable dt = ckmdl.SelectDatatable("Souko_Search", GetConnectionString(), soukoEntity.Sqlprms); return(dt); }
public DataTable M_Multiporpose_Search(multipurposeEntity multipurpose_entity) { ckmdl = new CKMDL(); multipurpose_entity.Sqlprms = new SqlParameter[6]; multipurpose_entity.Sqlprms[0] = new SqlParameter("@ID1", SqlDbType.Int) { Value = multipurpose_entity.ID1 }; multipurpose_entity.Sqlprms[1] = new SqlParameter("@ID2", SqlDbType.Int) { Value = multipurpose_entity.ID2 }; multipurpose_entity.Sqlprms[2] = new SqlParameter("@Key1", SqlDbType.VarChar) { Value = multipurpose_entity.Key1 }; multipurpose_entity.Sqlprms[3] = new SqlParameter("@Key2", SqlDbType.VarChar) { Value = multipurpose_entity.Key2 }; multipurpose_entity.Sqlprms[4] = new SqlParameter("@IDName", SqlDbType.VarChar) { Value = multipurpose_entity.IdName }; multipurpose_entity.Sqlprms[5] = new SqlParameter("@Type", SqlDbType.VarChar) { Value = multipurpose_entity.Type }; DataTable dt = ckmdl.SelectDatatable("M_Multiporpose_Search", GetConnectionString(), multipurpose_entity.Sqlprms); return(dt); }
//public string Shouhin_IUD(ShouhinEntity shouhin_entity) //{ // SqlConnection con = new SqlConnection(GetConnectionString()); // SqlCommand cmd = new SqlCommand("sp_Shouhin_IUD", con); // cmd.CommandType = CommandType.StoredProcedure; // CKMDL ckmdl = new CKMDL(); // shouhin_entity.Sqlprms = new SqlParameter[38]; // shouhin_entity.Sqlprms[0] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar) { Value = shouhin_entity.Product }; // shouhin_entity.Sqlprms[1] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = shouhin_entity.RevisionDate }; // shouhin_entity.Sqlprms[2] = new SqlParameter("@ShokutiFLG", SqlDbType.Int) { Value = shouhin_entity.ShokutiFLG }; // shouhin_entity.Sqlprms[3] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = shouhin_entity.ProductName }; // shouhin_entity.Sqlprms[4] = new SqlParameter("@ShouhinRyakuName", SqlDbType.VarChar) { Value = shouhin_entity.ShouhinRyakuName }; // shouhin_entity.Sqlprms[5] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = shouhin_entity.KatakanaName }; // shouhin_entity.Sqlprms[6] = new SqlParameter("@KensakuHyouziJun", SqlDbType.Int) { Value = shouhin_entity.KensakuHyouziJun }; // shouhin_entity.Sqlprms[7] = new SqlParameter("@JANCD", SqlDbType.VarChar) { Value = shouhin_entity.JANCD }; // shouhin_entity.Sqlprms[8] = new SqlParameter("@YearTerm", SqlDbType.VarChar) { Value = shouhin_entity.Exhibition }; // shouhin_entity.Sqlprms[9] = new SqlParameter("@SeasonSS", SqlDbType.VarChar) { Value = shouhin_entity.SS }; // shouhin_entity.Sqlprms[10] = new SqlParameter("@SeasonFW", SqlDbType.VarChar) { Value = shouhin_entity.FW }; // shouhin_entity.Sqlprms[11] = new SqlParameter("@TaniCD", SqlDbType.VarChar) { Value = shouhin_entity.TaniCD }; // shouhin_entity.Sqlprms[12] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = shouhin_entity.BrandCD }; // shouhin_entity.Sqlprms[13] = new SqlParameter("@ColorNO", SqlDbType.VarChar) { Value = shouhin_entity.Color }; // shouhin_entity.Sqlprms[14] = new SqlParameter("@SizeNO", SqlDbType.VarChar) { Value = shouhin_entity.Size }; // shouhin_entity.Sqlprms[15] = new SqlParameter("@JoudaiTanka", SqlDbType.VarChar) { Value = shouhin_entity.JoudaiTanka }; // shouhin_entity.Sqlprms[16] = new SqlParameter("@GedaiTanka", SqlDbType.VarChar) { Value = shouhin_entity.GedaiTanka }; // shouhin_entity.Sqlprms[17] = new SqlParameter("@HyoujunGenkaTanka", SqlDbType.VarChar) { Value = shouhin_entity.HyoujunGenkaTanka }; // shouhin_entity.Sqlprms[18] = new SqlParameter("@ZeirituKBN", SqlDbType.Int) { Value = shouhin_entity.ZeirituKBN }; // shouhin_entity.Sqlprms[19] = new SqlParameter("@ZaikoHyoukaKBN", SqlDbType.Int) { Value = shouhin_entity.ZaikoHyoukaKBN }; // shouhin_entity.Sqlprms[20] = new SqlParameter("@ZaikoKanriKBN", SqlDbType.Int) { Value = shouhin_entity.ZaikoKanriKBN }; // shouhin_entity.Sqlprms[21] = new SqlParameter("@MainSiiresakiCD", SqlDbType.VarChar) { Value = shouhin_entity.MainSiiresakiCD }; // shouhin_entity.Sqlprms[22] = new SqlParameter("@ToriatukaiShuuryouDate", SqlDbType.VarChar) { Value = shouhin_entity.ToriatukaiShuuryouDate }; // shouhin_entity.Sqlprms[23] = new SqlParameter("@HanbaiTeisiDate", SqlDbType.VarChar) { Value = shouhin_entity.HanbaiTeisiDate }; // shouhin_entity.Sqlprms[24] = new SqlParameter("@Model_No", SqlDbType.VarChar) { Value = shouhin_entity.Model_No }; // shouhin_entity.Sqlprms[25] = new SqlParameter("@Model_Name", SqlDbType.VarChar) { Value = shouhin_entity.Model_Name }; // shouhin_entity.Sqlprms[26] = new SqlParameter("@FOB", SqlDbType.VarChar) { Value = shouhin_entity.FOB }; // shouhin_entity.Sqlprms[27] = new SqlParameter("@Shipping_Place", SqlDbType.VarChar) { Value = shouhin_entity.Shipping_Place }; // shouhin_entity.Sqlprms[28] = new SqlParameter("@HacchuuLot", SqlDbType.Decimal) { Value = shouhin_entity.HacchuuLot }; // shouhin_entity.Sqlprms[29] = new SqlParameter("@ShouhinImageFilePathName", SqlDbType.VarChar) { Value = shouhin_entity.ImageFilePathName }; // shouhin_entity.Sqlprms[30] = new SqlParameter("@ShouhinImage", SqlDbType.VarBinary) { Value = shouhin_entity.Image }; // shouhin_entity.Sqlprms[31] = new SqlParameter("@Remarks", SqlDbType.VarChar) { Value = shouhin_entity.Remarks }; // shouhin_entity.Sqlprms[32] = new SqlParameter("@InsertOperator", SqlDbType.VarChar) { Value = shouhin_entity.InsertOperator }; // shouhin_entity.Sqlprms[33] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar) { Value = shouhin_entity.UpdateOperator }; // shouhin_entity.Sqlprms[34] = new SqlParameter("@Mode", SqlDbType.VarChar) { Value = shouhin_entity.Mode }; // shouhin_entity.Sqlprms[35] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = shouhin_entity.ProgramID }; // shouhin_entity.Sqlprms[36] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = shouhin_entity.PC }; // shouhin_entity.Sqlprms[37] = new SqlParameter("@KeyItem", SqlDbType.VarChar) { Value = shouhin_entity.KeyItem }; // return ckmdl.InsertUpdateDeleteData("sp_Shouhin_IUD", GetConnectionString(), shouhin_entity.Sqlprms); //} public DataTable Shouhin_Check(string shouhinCD, string colorno, string sizeno, string changeDate, string error_type) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[5]; parameters[0] = new SqlParameter("@shouhinCD", SqlDbType.VarChar) { Value = shouhinCD }; parameters[1] = new SqlParameter("@changeDate", SqlDbType.VarChar) { Value = changeDate }; parameters[2] = new SqlParameter("@error_type", SqlDbType.VarChar) { Value = error_type }; parameters[3] = new SqlParameter("@colorNO", SqlDbType.VarChar) { Value = colorno }; parameters[4] = new SqlParameter("@sizeNO", SqlDbType.VarChar) { Value = sizeno }; return(ckmdl.SelectDatatable("sp_Shouhin_Check", GetConnectionString(), parameters)); }
public DataTable ShokutiFLG_Select(string TokuisakiCD, string KouritenCD, string SiiresakiCD, string Condition) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = TokuisakiCD }; parameters[1] = new SqlParameter("@KouritenCD", SqlDbType.VarChar) { Value = KouritenCD }; parameters[2] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar) { Value = SiiresakiCD }; parameters[3] = new SqlParameter("@Condition", SqlDbType.VarChar) { Value = Condition }; DataTable dt = ckmdl.SelectDatatable("ShokutiFLG_Select", GetConnectionString(), parameters); return(dt); }
public DataTable Get_Max_HacchuuNO(string JuchuuNo, string SiiresakiCD, string SoukoCD, string HacchuuNO) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@JuchuuNO", SqlDbType.VarChar) { Value = JuchuuNo }; parameters[1] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar) { Value = SiiresakiCD }; parameters[2] = new SqlParameter("@SoukoCD", SqlDbType.VarChar) { Value = SoukoCD }; parameters[3] = new SqlParameter("@HacchuuNO", SqlDbType.VarChar) { Value = HacchuuNO }; DataTable dt = ckmdl.SelectDatatable("Get_Max_HacchuuNO", GetConnectionString(), parameters); return(dt); }
public DataTable M_Multiporpose_SelectData(string brandCD, int type, string id, string key) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = brandCD }; parameters[1] = new SqlParameter("@Type", SqlDbType.Int) { Value = type }; parameters[2] = new SqlParameter("@ID", SqlDbType.VarChar) { Value = id }; parameters[3] = new SqlParameter("@Key", SqlDbType.VarChar) { Value = key }; DataTable dt = ckmdl.SelectDatatable("M_Multiporpose_SelectData", GetConnectionString(), parameters); return(dt); }
public DataTable ChakuniNyuuryoku_Update_Select(ChakuniNyuuryoku_Entity ce, int type) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[6]; parameters[0] = new SqlParameter("@ChakuniNo", SqlDbType.VarChar) { Value = ce.ChakuniNO }; parameters[1] = new SqlParameter("@ChakuniDate", SqlDbType.VarChar) { Value = ce.ChakuniDate }; parameters[2] = new SqlParameter("@ModeType", SqlDbType.TinyInt) { Value = type }; parameters[3] = new SqlParameter("@Operator", SqlDbType.VarChar) { Value = ce.OperatorCD }; parameters[4] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = ce.ProgramID }; parameters[5] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = ce.PC }; DataTable dt = ckmdl.SelectDatatable("ChakuniNyuuryoku_Update_Select", GetConnectionString(), parameters); return(dt); }
public DataTable D_Exclusive_Lock_Check(ChakuniNyuuryoku_Entity ce) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[5]; parameters[0] = new SqlParameter("@Number", SqlDbType.VarChar) { Value = ce.Number }; parameters[1] = new SqlParameter("@OperatorCD", SqlDbType.VarChar) { Value = ce.OperatorCD }; parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = ce.ProgramID }; parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = ce.PC }; parameters[4] = new SqlParameter("@DataKBN", SqlDbType.Int) { Value = ce.DataKBN }; DataTable dt = ckmdl.SelectDatatable("D_Exclusive_Lock_Check", GetConnectionString(), parameters); return(dt); }
public DataTable GetAuthorization() { ckmdl = new CKMDL(); var parameters = new SqlParameter[] { }; DataTable dt = ckmdl.SelectDatatable("M_Authorization_Select", GetConnectionString(), parameters); return(dt); }
/// <summary> /// show message /// </summary> /// <param name="me"></param> /// <returns>dialogresult(ok,cancel,...)</returns> private DialogResult GetMessage(MessageEntity me) { me.Sqlprms = new SqlParameter[1]; me.Sqlprms[0] = new SqlParameter("@MessageID", me.MessageID); DataTable dtMsg = ckmdl.SelectDatatable("M_Message_Select", GetConnectionString(), me.Sqlprms); string message = string.Empty; string MessageID; if (dtMsg.Rows.Count > 0) { message = ReplaceMessage(dtMsg.Rows[0]["MessageText1"].ToString(), me); message += !string.IsNullOrWhiteSpace(dtMsg.Rows[0]["MessageText2"].ToString()) ? "\n\n" + ReplaceMessage(dtMsg.Rows[0]["MessageText2"].ToString(), me) : string.Empty; message += !string.IsNullOrWhiteSpace(dtMsg.Rows[0]["MessageText3"].ToString()) ? "\n\n" + ReplaceMessage(dtMsg.Rows[0]["MessageText3"].ToString(), me) : string.Empty; message += !string.IsNullOrWhiteSpace(dtMsg.Rows[0]["MessageText4"].ToString()) ? "\n\n" + ReplaceMessage(dtMsg.Rows[0]["MessageText4"].ToString(), me) : string.Empty; MessageID = !string.IsNullOrWhiteSpace(dtMsg.Rows[0]["MessageID"].ToString()) ? "\n\n" + ReplaceMessage(dtMsg.Rows[0]["MessageID"].ToString(), me) : string.Empty; // MessageID = ReplaceMessage(dtMsg.Rows[0]["MessageID"].ToString(), me); MessageBoxButtons msgbtn = dtMsg.Rows[0]["MessageButton"].ToString().Equals("1") ? MessageBoxButtons.OK : dtMsg.Rows[0]["MessageButton"].ToString().Equals("2") ? MessageBoxButtons.OKCancel : dtMsg.Rows[0]["MessageButton"].ToString().Equals("3") ? MessageBoxButtons.RetryCancel : dtMsg.Rows[0]["MessageButton"].ToString().Equals("4") ? MessageBoxButtons.YesNo : dtMsg.Rows[0]["MessageButton"].ToString().Equals("5") ? MessageBoxButtons.YesNoCancel : MessageBoxButtons.AbortRetryIgnore; MessageBoxIcon msgicon = dtMsg.Rows[0]["MessageMark"].ToString().Equals("1") ? MessageBoxIcon.Information : dtMsg.Rows[0]["MessageMark"].ToString().Equals("2") ? MessageBoxIcon.Asterisk : dtMsg.Rows[0]["MessageMark"].ToString().Equals("3") ? MessageBoxIcon.Question : dtMsg.Rows[0]["MessageMark"].ToString().Equals("4") ? MessageBoxIcon.Error : dtMsg.Rows[0]["MessageMark"].ToString().Equals("5") ? MessageBoxIcon.Stop : dtMsg.Rows[0]["MessageMark"].ToString().Equals("6") ? MessageBoxIcon.Exclamation : MessageBoxIcon.None; if (me.MessageID == "Q003") { return(MessageBox.Show(message, me.MessageID, msgbtn, msgicon, MessageBoxDefaultButton.Button2)); } else { return(MessageBox.Show(message, me.MessageID, msgbtn, msgicon, MessageBoxDefaultButton.Button1)); } } else { return(MessageBox.Show("システムで予約されたコード(メッセージマスタ未登録)", "エラー(" + me.MessageID + ")", MessageBoxButtons.OK, MessageBoxIcon.Error)); } }
public DataTable ShippingNO_Search(ShukkaSiziNyuuryokuEntity sksze) { CKMDL ckmdl = new CKMDL(); sksze.Sqlprms = new SqlParameter[11]; sksze.Sqlprms[0] = new SqlParameter("@ShukkaYoteiDate_From", SqlDbType.Date) { Value = sksze.ShukkaYoteiDate_From }; sksze.Sqlprms[1] = new SqlParameter("@ShukkaYoteiDate_To", SqlDbType.Date) { Value = sksze.ShukkaYoteiDate_To }; sksze.Sqlprms[2] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = sksze.TokuisakiCD }; sksze.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = sksze.StaffCD }; sksze.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = sksze.ShouhinName }; sksze.Sqlprms[5] = new SqlParameter("@DenpyouDate_From", SqlDbType.Date) { Value = sksze.DenpyouDate_From }; sksze.Sqlprms[6] = new SqlParameter("@DenpyouDate_To", SqlDbType.Date) { Value = sksze.DenpyouDate_To }; sksze.Sqlprms[7] = new SqlParameter("@ShukkaSiziNO_From", SqlDbType.VarChar) { Value = sksze.ShukkaSiziNO_From }; sksze.Sqlprms[8] = new SqlParameter("@ShukkaSiziNO_To", SqlDbType.VarChar) { Value = sksze.ShukkaSiziNO_To }; sksze.Sqlprms[9] = new SqlParameter("@ShouhinCD_From", SqlDbType.VarChar) { Value = sksze.ShouhinCD_From }; sksze.Sqlprms[10] = new SqlParameter("@ShouhinCD_To", SqlDbType.VarChar) { Value = sksze.ShouhinCD_To }; DataTable dt = ckmdl.SelectDatatable("ShippingNO_Search", GetConnectionString(), sksze.Sqlprms); return(dt); }
public DataTable ShukkaNo_Search(ShukkaNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); obj.Sqlprms = new SqlParameter[11]; obj.Sqlprms[0] = new SqlParameter("@ShukkaDate1", SqlDbType.VarChar) { Value = obj.ShukkaDate1 }; obj.Sqlprms[1] = new SqlParameter("@ShukkaDate2", SqlDbType.VarChar) { Value = obj.ShukkaDate2 }; obj.Sqlprms[2] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = obj.TokuisakiCD }; obj.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; obj.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; obj.Sqlprms[5] = new SqlParameter("@ShukkaNO1", SqlDbType.VarChar) { Value = obj.ShukkaNO1 }; obj.Sqlprms[6] = new SqlParameter("@ShukkaNO2", SqlDbType.VarChar) { Value = obj.ShukkaNO2 }; obj.Sqlprms[7] = new SqlParameter("@ShukkaSiziNO1", SqlDbType.VarChar) { Value = obj.ShukkaSiziNO1 }; obj.Sqlprms[8] = new SqlParameter("@ShukkaSiziNO2", SqlDbType.VarChar) { Value = obj.ShukkaSiziNO2 }; obj.Sqlprms[9] = new SqlParameter("@ShouhinCD1", SqlDbType.VarChar) { Value = obj.ShouhinCD1 }; obj.Sqlprms[10] = new SqlParameter("@ShouhinCD2", SqlDbType.VarChar) { Value = obj.ShouhinCD2 }; DataTable dt = ckmdl.SelectDatatable("ShukkaNo_Search", GetConnectionString(), obj.Sqlprms); return(dt); }
public DataTable ChakuniYoteiNyuuryoku_Search(ChakuniYoteiNyuuryokuEntity cyn) { CKMDL ckmdl = new CKMDL(); cyn.Sqlprms = new SqlParameter[11]; cyn.Sqlprms[0] = new SqlParameter("@DateFrom", SqlDbType.VarChar) { Value = cyn.ChakuniYoteiDateFrom }; cyn.Sqlprms[1] = new SqlParameter("@DateTo", SqlDbType.VarChar) { Value = cyn.ChakuniYoteiDateTo }; cyn.Sqlprms[2] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar) { Value = cyn.SiiresakiCD }; cyn.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = cyn.StaffCD }; cyn.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = cyn.ShouhinName }; cyn.Sqlprms[5] = new SqlParameter("@HacchuuDateFrom", SqlDbType.VarChar) { Value = cyn.HacchuuDateFrom }; cyn.Sqlprms[6] = new SqlParameter("@HacchuuDateTo", SqlDbType.VarChar) { Value = cyn.HacchuuDateTo }; cyn.Sqlprms[7] = new SqlParameter("@KanriNOFrom", SqlDbType.VarChar) { Value = cyn.KanriNOFrom }; cyn.Sqlprms[8] = new SqlParameter("@KanriNOTo", SqlDbType.VarChar) { Value = cyn.KanriNOTo }; cyn.Sqlprms[9] = new SqlParameter("@ShouhinCDFrom", SqlDbType.VarChar) { Value = cyn.ShouhinCDFrom }; cyn.Sqlprms[10] = new SqlParameter("@ShouhinCDTo", SqlDbType.VarChar) { Value = cyn.ShouhinCDTo }; DataTable dt = ckmdl.SelectDatatable("ChakuniYoteiNyuuryoku_Search", GetConnectionString(), cyn.Sqlprms); return(dt); }
public DataTable ArrivalNO_Search(ChakuniNyuuryoku_Entity ane) { CKMDL ckmdl = new CKMDL(); ane.Sqlprms = new SqlParameter[11]; ane.Sqlprms[0] = new SqlParameter("@ChakuniDateFrom", SqlDbType.VarChar) { Value = ane.ChakuniDateFrom }; ane.Sqlprms[1] = new SqlParameter("@ChakuniDateTo", SqlDbType.VarChar) { Value = ane.ChakuniDateTo }; ane.Sqlprms[2] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar) { Value = ane.SiiresakiCD }; ane.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = ane.StaffCD }; ane.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = ane.ShouhinName }; ane.Sqlprms[5] = new SqlParameter("@ChakuniYoteiDateFrom", SqlDbType.VarChar) { Value = ane.ChakuniYoteiDateFrom }; ane.Sqlprms[6] = new SqlParameter("@ChakuniYoteiDateTo", SqlDbType.VarChar) { Value = ane.ChakuniYoteiDateTo }; ane.Sqlprms[7] = new SqlParameter("@KanriNOFrom", SqlDbType.VarChar) { Value = ane.KanriNOFrom }; ane.Sqlprms[8] = new SqlParameter("@KanriNOTo", SqlDbType.VarChar) { Value = ane.KanriNOTo }; ane.Sqlprms[9] = new SqlParameter("@ShouhinCDFrom", SqlDbType.VarChar) { Value = ane.ShouhinCDFrom }; ane.Sqlprms[10] = new SqlParameter("@ShouhinCDTo", SqlDbType.VarChar) { Value = ane.ShouhinCDTo }; DataTable dt = ckmdl.SelectDatatable("ArrivalNO_Search", GetConnectionString(), ane.Sqlprms); return(dt); }
public DataTable JuchuuNyuuryoku_Search(JuchuuNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[11]; parameters[0] = new SqlParameter("@JuchuuDateFrom", SqlDbType.VarChar) { Value = obj.JuchuuDateFrom }; parameters[1] = new SqlParameter("@JuchuuDateTo", SqlDbType.VarChar) { Value = obj.JuchuuDateTo }; parameters[2] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = obj.TokuisakiCD }; parameters[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[5] = new SqlParameter("@JuchuuNoFrom", SqlDbType.VarChar) { Value = obj.JuchuuNoFrom }; parameters[6] = new SqlParameter("@JuchuuNoTo", SqlDbType.VarChar) { Value = obj.JuchuuNoTo }; parameters[7] = new SqlParameter("@HacchuNoFrom", SqlDbType.VarChar) { Value = obj.HacchuNoFrom }; parameters[8] = new SqlParameter("@HacchuNoTo", SqlDbType.VarChar) { Value = obj.HacchuNoTo }; parameters[9] = new SqlParameter("@ShouhinCDFrom", SqlDbType.VarChar) { Value = obj.ShouhinCDFrom }; parameters[10] = new SqlParameter("@ShouhinCDTo", SqlDbType.VarChar) { Value = obj.ShouhinCDTo }; DataTable dt = ckmdl.SelectDatatable("JuchuuNyuuryoku_Search", GetConnectionString(), parameters); return(dt); }
public SoukoEntity GetSoukoEntity(SoukoEntity soukoEntity) { soukoEntity.Sqlprms = new SqlParameter[0]; DataTable dtSouko = ckmdl.SelectDatatable("M_Souko_Select", GetConnectionString(), soukoEntity.Sqlprms); if (dtSouko.Rows.Count > 0) { soukoEntity.SoukoCD = dtSouko.Rows[0]["SoukoCD"].ToString(); soukoEntity.SoukoName = dtSouko.Rows[0]["SoukoName"].ToString(); } return(soukoEntity); }
public DataTable IdouNyuuryoku_Display(IdouNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[11]; parameters[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = obj.BrandCD }; parameters[1] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar) { Value = obj.ShouhinCD }; parameters[2] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[3] = new SqlParameter("@JANCD", SqlDbType.VarChar) { Value = obj.JANCD }; parameters[4] = new SqlParameter("@YearTerm", SqlDbType.VarChar) { Value = obj.YearTerm }; parameters[5] = new SqlParameter("@SeasonSS", SqlDbType.VarChar) { Value = obj.SeasonSS }; parameters[6] = new SqlParameter("@SeasonFW", SqlDbType.VarChar) { Value = obj.SeasonFW }; parameters[7] = new SqlParameter("@ColorNo", SqlDbType.VarChar) { Value = obj.ColorNO }; parameters[8] = new SqlParameter("@SizeNo", SqlDbType.VarChar) { Value = obj.SizeNO }; parameters[9] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; parameters[10] = new SqlParameter("@SoukoCD", SqlDbType.VarChar) { Value = obj.SoukoCD }; DataTable dt = ckmdl.SelectDatatable("IdouNyuuryoku_Display", GetConnectionString(), parameters); return(dt); }
public DataTable HacchuuNyuuryoku_Search(HacchuuNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[11]; parameters[0] = new SqlParameter("@Date1", SqlDbType.VarChar) { Value = obj.Date1 }; parameters[1] = new SqlParameter("@Date2", SqlDbType.VarChar) { Value = obj.Date2 }; parameters[2] = new SqlParameter("@SiireSakiCD", SqlDbType.VarChar) { Value = obj.SiiresakiCD }; parameters[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[5] = new SqlParameter("@HacchuuNo11", SqlDbType.VarChar) { Value = obj.NO11 }; parameters[6] = new SqlParameter("@HacchuuNo12", SqlDbType.VarChar) { Value = obj.NO12 }; parameters[7] = new SqlParameter("@JuchuuNo21", SqlDbType.VarChar) { Value = obj.NO21 }; parameters[8] = new SqlParameter("@JuchuuNo22", SqlDbType.VarChar) { Value = obj.NO22 }; parameters[9] = new SqlParameter("@ShouhinCD1", SqlDbType.VarChar) { Value = obj.ShouhinCD1 }; //TaskNo521 HET parameters[10] = new SqlParameter("@ShouhinCD2", SqlDbType.VarChar) { Value = obj.ShouhinCD2 }; //TaskNo521 HET DataTable dt = ckmdl.SelectDatatable("HacchuuNyuuryoku_Search", GetConnectionString(), parameters); return(dt); }
public DataTable Kouriten_Search(KouritenEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[10]; parameters[0] = new SqlParameter("@KouritenCD1", SqlDbType.VarChar) { Value = obj.KouritenCD }; parameters[1] = new SqlParameter("@KouritenCD2", SqlDbType.VarChar) { Value = obj.KouritenRyakuName }; parameters[2] = new SqlParameter("@KouritenName", SqlDbType.VarChar) { Value = obj.KouritenName }; parameters[3] = new SqlParameter("@KanaName", SqlDbType.VarChar) { Value = obj.KanaName }; parameters[4] = new SqlParameter("@TokuisakiCD1", SqlDbType.VarChar) { Value = obj.TokuisakiCD }; parameters[5] = new SqlParameter("@TokuisakiCD2", SqlDbType.VarChar) { Value = obj.MailAddress }; parameters[6] = new SqlParameter("@TokuisakiName", SqlDbType.VarChar) { Value = obj.Juusho1 }; parameters[7] = new SqlParameter("@Tokuisaki_Kana", SqlDbType.VarChar) { Value = obj.Juusho2 }; parameters[8] = new SqlParameter("@RadioCheck", SqlDbType.VarChar) { Value = obj.Remarks }; parameters[9] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; DataTable dt = ckmdl.SelectDatatable("Kouriten_Search", GetConnectionString(), parameters); return(dt); }
public DataTable ChakuniYoteiDataCheck(ChakuniYoteiNyuuryokuEntity cyn) { CKMDL ckmdl = new CKMDL(); cyn.Sqlprms = new SqlParameter[1]; cyn.Sqlprms[0] = new SqlParameter("@KanriNO", SqlDbType.VarChar) { Value = cyn.KanriNO }; DataTable dt = ckmdl.SelectDatatable("ChakuniYotei_DataCheck", GetConnectionString(), cyn.Sqlprms); return(dt); }
public string ExistsCheck(BaseModel baseModel) { baseModel.Sqlprms = new SqlParameter[2]; baseModel.Sqlprms[0] = new SqlParameter("@param1", baseModel.param1); baseModel.Sqlprms[1] = new SqlParameter("@param2", baseModel.param2); DataTable dt = cKMDL.SelectDatatable("Check_DataExists", ff.GetConnectionWithDefaultPath("PJMS"), baseModel.Sqlprms); if (dt.Rows.Count > 0) { return("1"); } return("0"); }
public DataTable IdouNyuuryo_Search(IdouNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[10]; parameters[0] = new SqlParameter("@Date1", SqlDbType.VarChar) { Value = obj.Date1 }; parameters[1] = new SqlParameter("@Date2", SqlDbType.VarChar) { Value = obj.Date2 }; parameters[2] = new SqlParameter("@ShukkoSoukoCD", SqlDbType.VarChar) { Value = obj.ShukkoSoukoCD }; parameters[3] = new SqlParameter("@NyuukoSoukoCD", SqlDbType.VarChar) { Value = obj.NyuukoSoukoCD }; parameters[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[5] = new SqlParameter("@IdouNO1", SqlDbType.VarChar) { Value = obj.IdouNO1 }; parameters[6] = new SqlParameter("@IdouNO2", SqlDbType.VarChar) { Value = obj.IdouNO2 }; parameters[7] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[8] = new SqlParameter("@ShouhinCD1", SqlDbType.VarChar) { Value = obj.ShouhinCD1 }; parameters[9] = new SqlParameter("@ShouhinCD2", SqlDbType.VarChar) { Value = obj.ShouhinCD2 }; DataTable dt = ckmdl.SelectDatatable("IdouNyuuryo_Search", GetConnectionString(), parameters); return(dt); }