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