public string ShukkaNyuuryoku_Exclusive_Insert(ShukkaNyuuryokuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.VarChar)
{
Value = "6"
};
parameters[1] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = obj.ShukkaNO1
};
parameters[2] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = obj.OperatorCD
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.ProgramID
};
parameters[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
return(ckmdl.InsertUpdateDeleteData("D_Exclusive_Insert", GetConnectionString(), parameters));
}
public DataTable D_Exclusive_Lock_Check(ShukkaNyuuryokuEntity se)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.Int)
{
Value = se.DataKBN
};
parameters[1] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = se.Number
};
parameters[2] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = se.OperatorCD
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = se.ProgramID
};
parameters[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = se.PC
};
DataTable dt = ckmdl.SelectDatatable("D_Exclusive_Lock_Check", GetConnectionString(), parameters);
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);
}
private void DataGridviewBind()
{
ShukkaNyuuryokuEntity obj = new ShukkaNyuuryokuEntity();
if (cf.DateCheck(txtShukkaDate1)) //Task no. 147 - tza
{
obj.ShukkaDate1 = txtShukkaDate1.Text;
}
if (cf.DateCheck(txtShukkaDate2)) //Task no. 147 - tza
{
obj.ShukkaDate2 = txtShukkaDate2.Text;
}
obj.TokuisakiCD = txt_Tokuisaki.Text;
obj.StaffCD = txt_StaffCD.Text;
obj.ShouhinName = txtShouhinName.Text;
obj.ShukkaNO1 = txtShukkaNo1.Text;
obj.ShukkaNO2 = txtShukkaNo2.Text;
obj.ShukkaSiziNO1 = txtShukkaSijiNo1.Text;
obj.ShukkaSiziNO2 = txtShukkaSijiNo2.Text;
obj.ShouhinCD1 = txtShouhin1.Text;
obj.ShouhinCD2 = txtShouhin2.Text;
if (ErrorCheck(panel1)) //Task no. 147 - tza
{
ShukkaNyuuryokuBL sBL = new ShukkaNyuuryokuBL();
DataTable dt = sBL.ShukkaNo_Search(obj);
if (dt.Columns.Contains("CurrentDay"))
{
if (dt.Rows.Count > 0)
{
lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
txtCurrentDate.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
}
else
{
ClearSession();
}
}
dt.Columns.Remove("CurrentDay");
gvShukkaNo.DataSource = dt;
}
}
public DataTable ShukkaNyuuryoku_Select_Check(string shukkaNo, string shukkaDate, string errtype)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[3];
ShukkaNyuuryokuEntity obj = new ShukkaNyuuryokuEntity();
parameters[0] = new SqlParameter("@ShukkaNo", SqlDbType.VarChar)
{
Value = shukkaNo
};
parameters[1] = new SqlParameter("@ShukkaDate", SqlDbType.VarChar)
{
Value = shukkaDate
};
parameters[2] = new SqlParameter("@Errortype", SqlDbType.VarChar)
{
Value = errtype
};
DataTable dt = ckmdl.SelectDatatable("ShukkaNyuuryoku_Select_Check", GetConnectionString(), parameters);
return(dt);
}
public string D_Exclusive_ShukkaSiZiNo_Delete(ShukkaNyuuryokuEntity se)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.TinyInt)
{
Value = se.DataKBN
};
parameters[1] = new SqlParameter("@OperatorCD", 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
};
return(ckmdl.InsertUpdateDeleteData("D_Exclusive_Remove_NO", GetConnectionString(), parameters));
}
public DataTable ShukkaNyuuryoku_Display(ShukkaNyuuryokuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[18];
parameters[0] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar)
{
Value = obj.TokuisakiCD
};
parameters[1] = new SqlParameter("@ShukkaSiziNO", SqlDbType.VarChar)
{
Value = obj.ShukkaSiziNO1
};
parameters[2] = new SqlParameter("@ShukkaYoteiDate1", SqlDbType.VarChar)
{
Value = obj.ShukkaDate1
};
parameters[3] = new SqlParameter("@ShukkaYoteiDate2", SqlDbType.VarChar)
{
Value = obj.ShukkaDate2
};
parameters[4] = new SqlParameter("@DenpyouDate1", SqlDbType.VarChar)
{
Value = obj.DenpyouDate1
};
parameters[5] = new SqlParameter("@DenpyouDate2", SqlDbType.VarChar)
{
Value = obj.DenpyouDate2
};
parameters[6] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
parameters[7] = new SqlParameter("@YuubinNO1", SqlDbType.VarChar)
{
Value = obj.Yuubin1
};
parameters[8] = new SqlParameter("@YuubinNO2", SqlDbType.VarChar)
{
Value = obj.Yuubin2
};
parameters[9] = new SqlParameter("@TelNO1", SqlDbType.VarChar)
{
Value = obj.TelNO1
};
parameters[10] = new SqlParameter("@TelNO2", SqlDbType.VarChar)
{
Value = obj.TelNO2
};
parameters[11] = new SqlParameter("@TelNO3", SqlDbType.VarChar)
{
Value = obj.TelNO3
};
parameters[12] = new SqlParameter("@Name", SqlDbType.VarChar)
{
Value = obj.Name
};
parameters[13] = new SqlParameter("@Juusho", SqlDbType.VarChar)
{
Value = obj.Juusho
};
parameters[14] = new SqlParameter("@Condition", SqlDbType.VarChar)
{
Value = obj.Condition
};
parameters[15] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = obj.OperatorCD
};
parameters[16] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = obj.ProgramID
};
parameters[17] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = obj.PC
};
DataTable dt = ckmdl.SelectDatatable("ShukkaNyuuryoku_Display", GetConnectionString(), parameters);
return(dt);
}