public static List<PersonInfo> GetPersonInfoByTrueName(string TrueName)
{
List<PersonInfo> list2;
try
{
Sql2KDataAccess access = new Sql2KDataAccess();
List<PersonInfo> list = new List<PersonInfo>();
DataSet set = access.Run_SqlText("select * from t_user where TrueName='" + TrueName + "'");
if ((set != null) && (set.Tables[0].Rows.Count > 0))
{
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
PersonInfo item = new PersonInfo {
UserName = set.Tables[0].Rows[i]["UserName"].ToString(),
TrueName = set.Tables[0].Rows[i]["TrueName"].ToString(),
BarCode = set.Tables[0].Rows[i]["BarCode"].ToString()
};
list.Add(item);
}
}
list2 = list;
}
catch (Exception exception)
{
throw exception;
}
return list2;
}
public bool NewSendList(string TaskId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@TaskId", TaskId.Trim());
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoReturn(hT, "P_OutStorage");
}
public static string CreateWorkPlanID()
{
Hashtable hT = new Hashtable();
Sql2KDataAccess access = new Sql2KDataAccess();
m_IntWorkPlanID = Convert.ToInt32(access.RunProcedureNoRecord("@NewWorkPlanID", SqlDbType.Char, hT, "P_CreateWorkPlanID").Trim());
m_StrWorkPlanID = "W" + DateTime.Now.ToString("yyyyMMdd") + m_IntWorkPlanID.ToString("D3");
return m_StrWorkPlanID;
}
public bool NewSend(string TaskStr)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@TaskIDStr", TaskStr.Trim());
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoReturn(hT, "P_CreateNewSend");
}
public bool NpToTask(string TaskId, string NpId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@TaskId", TaskId);
hT.Add("@NpId", NpId);
return access.RunProcedureNoReturn(hT, "P_NpToTask");
}
public bool PlanToTask(string PlanId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@PlanId", PlanId);
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoReturn(hT, "P_PlanToTask");
}
public string NewTask()
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
new DataSet();
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoRecord("@TaskId", SqlDbType.VarChar, hT, "P_NewTask");
}
public DataSet GetNewTask()
{
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet dataset = new DataSet();
Hashtable hT = new Hashtable();
access.RunProcedure(ref dataset, hT, "P_GetNewMbTask");
return dataset;
}
public static DataSet GetTodayWork(DateTime theDay)
{
string queryStr = "";
DataSet set = new DataSet();
Sql2KDataAccess access = new Sql2KDataAccess();
queryStr = "select * from v_workplan where datediff(day,'" + theDay + "',WorkDay)=0";
return access.Run_SqlText(queryStr);
}
public int GetBoxCapability()
{
Sql2KDataAccess access = new Sql2KDataAccess();
new DataSet();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "MbBoxCapability");
hT.Add("@UserName", User.UserName);
return int.Parse(access.RunProcedureNoRecord("@SetValue", SqlDbType.VarChar, hT, "P_GetSet"));
}
public static string GetSendPrinter()
{
Sql2KDataAccess access = new Sql2KDataAccess();
new DataSet();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "SendPrinter");
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoRecord("@SetValue", SqlDbType.VarChar, hT, "P_GetSet");
}
public DataSet PrintTaskList(string TaskId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
new Hashtable();
DataSet ds = new DataSet();
access.Run_SqlText(ref ds, "select * from V_Task Where TaskId='" + TaskId.Trim() + "'", "V_Task");
access.Run_SqlText(ref ds, "select * from V_Np Where TaskId='" + TaskId.Trim() + "' Order By NpNo ", "V_Np");
return ds;
}
public DataSet GetNpByTaskId(string TaskId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@TaskId", TaskId);
access.RunProcedure(ref dataset, hT, "P_GetNpByTaskId");
return dataset;
}
public DataSet GetToDoNp(string PlanId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@PlanId", PlanId.Trim());
access.RunProcedure(ref dataset, hT, "P_GetToDoNp");
return dataset;
}
public static bool SaveSendPrinter(string SendPrinter)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "SendPrinter");
hT.Add("@SetValue", SendPrinter);
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoReturn(hT, "P_SaveSet");
}
public bool SaveBoxCapability(int Capability)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@SetKey", "MbBoxCapability");
hT.Add("@SetValue", Capability);
hT.Add("@UserName", User.UserName);
return access.RunProcedureNoReturn(hT, "P_SaveSet");
}
public DataSet GetToDoPan(string MbType, string WProcedure)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
DataSet dataset = new DataSet();
hT.Add("@MbType", MbType);
hT.Add("@CurrentProcedure", WProcedure);
access.RunProcedure(ref dataset, hT, "P_GetToDoPan");
return dataset;
}
public string NewTask(string MbType, long MbAmount, string WProcedure)
{
Sql2KDataAccess access = new Sql2KDataAccess();
Hashtable hT = new Hashtable();
hT.Add("@UserName", User.UserName);
hT.Add("@MbType", MbType);
hT.Add("@MbAmount", MbAmount);
hT.Add("@WProcedure", WProcedure);
return access.RunProcedureNoRecord("@MbTaskId", SqlDbType.VarChar, hT, "P_NewMbTask");
}
public DataSet PrintSendList(string SendId)
{
Sql2KDataAccess access = new Sql2KDataAccess();
new Hashtable();
DataSet ds = new DataSet();
access.Run_SqlText(ref ds, "select * from V_SendList Where SendId='" + SendId.Trim() + "'", "V_SendList");
access.Run_SqlText(ref ds, "select * from V_List Where SendId='" + SendId.Trim() + "'", "V_List");
access.Run_SqlText(ref ds, "select * from V_Np Where SendId='" + SendId.Trim() + "'", "V_Np");
return ds;
}
public static void InsertWorkPlan(DataSet WorkPlanSet)
{
if ((WorkPlanSet != null) && (WorkPlanSet.Tables[0].Rows.Count != 0))
{
string queryStr = "";
Sql2KDataAccess access = new Sql2KDataAccess();
for (int i = 0; i < WorkPlanSet.Tables[0].Rows.Count; i++)
{
queryStr = string.Concat(new object[] { "Insert into t_WorkPlan(WorkPLanID,UserName,ProcessID,WorkLoad,WorkDay,MakeTime,MakePeron,Remark) values('", WorkPlanSet.Tables[0].Rows[i]["WorkPLanID"].ToString(), "','", WorkPlanSet.Tables[0].Rows[i]["UserName"].ToString(), "','", WorkPlanSet.Tables[0].Rows[i]["ProcessID"].ToString(), "',", int.Parse(WorkPlanSet.Tables[0].Rows[i]["WorkLoad"].ToString()), ",'", WorkPlanSet.Tables[0].Rows[i]["WorkDay"].ToString(), "',getdate(),'", WorkPlanSet.Tables[0].Rows[i]["MakePeron"].ToString(), "','", WorkPlanSet.Tables[0].Rows[i]["Remark"].ToString(), "')" });
access.Run_SqlText(queryStr);
}
}
}
public static void InsertFixedBox(DataSet FixedBoxSet)
{
if ((FixedBoxSet != null) && (FixedBoxSet.Tables[0].Rows.Count != 0))
{
string queryStr = "";
Sql2KDataAccess access = new Sql2KDataAccess();
for (int i = 0; i < FixedBoxSet.Tables[0].Rows.Count; i++)
{
queryStr = "Insert into t_WorkPlanFixedBox(WorkPLanID,TaskID) values('" + FixedBoxSet.Tables[0].Rows[i]["WorkPlanID"].ToString() + "','" + FixedBoxSet.Tables[0].Rows[i]["TaskID"].ToString() + "')";
access.Run_SqlText(queryStr);
}
}
}
public bool InsertToDBWarehouse(string TaskID, string OperateType, DateTime OperateTime, string HandlePerson, string OperationPerson)
{
string str;
bool flag = false;
if (((TaskID.Trim().Length < 1) || (OperateType.Trim().Length < 1)) || (OperationPerson.Trim().Length < 1))
{
return false;
}
if (TaskID.Substring(0, 1).CompareTo("T") == 0)
{
if (OperateType.CompareTo("入库") == 0)
{
str = "update T_Task set IsInWarehouse=1 where taskid='" + TaskID + "'";
}
else
{
str = "update T_Task set IsInWarehouse=0 where taskid='" + TaskID + "'";
}
}
else if (OperateType.CompareTo("入库") == 0)
{
str = "update T_PanTaskInfo set IsInWarehouse=1 where Pantaskid='" + TaskID + "'";
}
else
{
str = "update T_PanTaskInfo set IsInWarehouse=0 where Pantaskid='" + TaskID + "'";
}
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet set = new DataSet();
set = access.Run_SqlText(str);
str = string.Concat(new object[] { "insert into T_WarehouseOperation(TaskID , OperateType , OperateTime ,HandlePerson , OperatePerson ) values('", TaskID, "','", OperateType, "','", OperateTime, "','", HandlePerson, "','", OperationPerson, "')" });
if (access.Run_SqlText(str) != null)
{
flag = true;
}
access = null;
return flag;
}
private void btn_PlanIdQuery_Click(object sender, EventArgs e)
{
if (this.txt_PlanId.Text.Trim() == "")
{
MessageBox.Show("请输入要查询的计划单号", "计划单查询", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.txt_PlanId.Focus();
}
else
{
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet set = new DataSet();
if (!this.cbx_Big.Checked)
{
set = access.Run_SqlText(this.PlanResult + " where PlanId='" + this.txt_PlanId.Text.Trim() + "' Order By PlanTime desc");
}
else
{
set = access.Run_SqlText(this.PlanResult + " where PlanId like '" + this.txt_PlanId.Text.Trim() + "%' Order By PlanTime desc");
}
this.dgv_Plan.DataSource = set.Tables[0];
this.lab_Total.Text = "共查询到 " + set.Tables[0].Rows.Count.ToString() + " 条符合条件的记录";
}
}
public void PrintSendDetail()
{
try
{
CpNpStat stat = new CpNpStat();
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet ds = new DataSet();
access.Run_SqlText(ref ds, "select Description ,TotalNum from V_NpType t inner join (select Code,Count(NpId) as TotalNum from V_Np Where InPutTime between '" + this.m_FromDate.ToShortDateString() + "' and '" + this.ToDate.AddDays(1.0).ToShortDateString() + "'" + this.m_State + " Group By Code) t1 on t.Code=t1.Code", "V_NpStat");
ParameterFields fields = new ParameterFields();
ParameterField field = new ParameterField();
ParameterDiscreteValue value2 = new ParameterDiscreteValue();
field.ParameterFieldName="FromDate";
value2.Value=this.m_FromDate.ToShortDateString();
field.CurrentValues.Add(value2);
fields.Add(field);
field = new ParameterField();
field.ParameterFieldName="ToDate";
value2 = new ParameterDiscreteValue();
value2.Value=this.m_ToDate.ToShortDateString();
field.CurrentValues.Add(value2);
fields.Add(field);
field = new ParameterField();
field.ParameterFieldName="State";
value2 = new ParameterDiscreteValue();
value2.Value=this.StateDesc;
field.CurrentValues.Add(value2);
fields.Add(field);
this.crv_Send.ParameterFieldInfo=fields;
ds.Tables[0].TableName = "V_NpState";
stat.SetDataSource(ds);
this.crv_Send.ReportSource=stat;
this.crv_Send.PrintReport();
}
catch (Exception exception)
{
MessageBox.Show("打印时发生错误" + '\n' + exception.Message, "打印生产量统计", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btn_PlanId_Click(object sender, EventArgs e)
{
if (this.tbx_PlanId.Text.Trim() == "")
{
MessageBox.Show("请输入要查询的计划单号", "车牌查询", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
DataSet set = new Sql2KDataAccess().Run_SqlText(this.NpResult + " where PlanId='" + this.tbx_PlanId.Text.Trim() + "'");
this.drw_NpResult.DataSource = set.Tables[0];
this.labTotal.Text = "共查询到 " + set.Tables[0].Rows.Count.ToString() + " 条符合条件的记录";
}
}
private void Frm_NpStat_Load(object sender, EventArgs e)
{
CpNpStat stat = new CpNpStat();
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet ds = new DataSet();
access.Run_SqlText(ref ds, "select Description ,TotalNum from V_NpType t inner join (select Code,Count(NpId) as TotalNum from V_Np Where InPutTime between '" + this.m_FromDate.ToShortDateString() + "' and '" + this.ToDate.AddDays(1.0).ToShortDateString() + "'" + this.m_State + " Group By Code) t1 on t.Code=t1.Code", "V_NpStat");
ParameterFields fields = new ParameterFields();
ParameterField field = new ParameterField();
ParameterDiscreteValue value2 = new ParameterDiscreteValue();
field.ParameterFieldName="FromDate";
value2.Value=this.m_FromDate.ToShortDateString();
field.CurrentValues.Add(value2);
fields.Add(field);
field = new ParameterField();
field.ParameterFieldName="ToDate";
value2 = new ParameterDiscreteValue();
value2.Value=this.m_ToDate.ToShortDateString();
field.CurrentValues.Add(value2);
fields.Add(field);
field = new ParameterField();
field.ParameterFieldName="State";
value2 = new ParameterDiscreteValue();
value2.Value=this.StateDesc;
field.CurrentValues.Add(value2);
fields.Add(field);
this.crv_Send.ParameterFieldInfo=fields;
stat.SetDataSource(ds);
this.crv_Send.ReportSource=stat;
}
private void btnPrint_Click(object sender, EventArgs e)
{
PrintDocument document = new PrintDocument();
document.PrintPage += new PrintPageEventHandler(this.Pd_PrintPageSend);
try
{
PrintPreviewDialog dialog = new PrintPreviewDialog {
Document = document
};
PaperSize size = new PaperSize {
Height = 0x21f,
Width = 0x33b
};
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet set = access.Run_SqlText("select * from d_code where codetype=8 and code='SendListOff'");
try
{
size.Height = int.Parse(set.Tables[0].Rows[0]["codename"].ToString());
}
catch
{
size.Height = 0x229;
string queryStr = "insert into d_code(code,codetype,codename,description) values('SendListOff',8,'" + size.Height + "','打印纸高度')";
access.Run_SqlText(queryStr);
}
document.DefaultPageSettings.PaperSize = size;
document.PrinterSettings.PrinterName = Invoice.GetSendPrinter();
dialog.WindowState = FormWindowState.Maximized;
if (this.IsPreview)
{
dialog.ShowDialog();
}
else
{
document.Print();
}
}
catch (Exception exception)
{
MessageBox.Show("打印时发生错误" + '\n' + exception.Message, "打印送货单", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void FrmPrintSendList_Load(object sender, EventArgs e)
{
List<User.PersonInfo> personInfoByUserName = User.GetPersonInfoByUserName(User.UserName);
if (personInfoByUserName.Count > 0)
{
this.labelMakeperson.Text = "制表人 " + personInfoByUserName[0].TrueName;
}
this.labelMakeTime.Text = "制表时间 " + DateTime.Now;
Sql2KDataAccess access = new Sql2KDataAccess();
DataSet set = new DataSet();
set = access.Run_SqlText("select * from d_code where codetype=8 and code='SendPerson'");
try
{
this.textSendPerson.Text = set.Tables[0].Rows[0]["codename"].ToString();
}
catch
{
this.textSendPerson.Text = "程道民";
string queryStr = "insert into d_code(code,codetype,codename,description) values('SendPerson',8,'" + this.textSendPerson.Text + "','送货人')";
access.Run_SqlText(queryStr);
}
this.IsPreview = false;
}
private void btn_PrintCode_Click(object sender, EventArgs e)
{
int boxCapability = new MbTask().GetBoxCapability();
try
{
if (this.dgv_Mboard.SelectedCells[2].Value.ToString().Trim() != "清洗烘干")
{
MessageBox.Show("只有清洗烘干工序可以打印条形码", "底板任务查询", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
PanBarCode[] codeArray;
if ((int.Parse(this.dgv_Mboard.SelectedCells[3].Value.ToString()) % boxCapability) != 0)
{
int num1 = int.Parse(this.dgv_Mboard.SelectedCells[3].Value.ToString()) / boxCapability;
}
else
{
int num3 = int.Parse(this.dgv_Mboard.SelectedCells[3].Value.ToString()) / boxCapability;
}
string queryStr = "select * from t_pantaskinfo where left(pantaskid,12)='" + this.dgv_Mboard.SelectedCells[0].Value.ToString() + "'";
DataSet set = new Sql2KDataAccess().Run_SqlText(queryStr);
if ((set != null) && (set.Tables[0].Rows.Count > 0))
{
codeArray = new PanBarCode[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
codeArray[i].strCount = set.Tables[0].Rows[i]["pancount"].ToString();
codeArray[i].strTaskID = set.Tables[0].Rows[i]["pantaskid"].ToString();
codeArray[i].strPanType = this.dgv_Mboard.SelectedCells[1].Value.ToString();
}
}
else
{
codeArray = new PanBarCode[0];
}
new Print().LabelPrintTaskPan(codeArray);
}
}
catch (Exception exception)
{
MessageBox.Show("打印条形码时发生错误\n" + exception.Message, "底板任务管理", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void btn_PlanId_Task_Click(object sender, EventArgs e)
{
if (this.tbx_PlanId_Task.Text.Trim() == "")
{
MessageBox.Show("请输入要查询的计划单号", "送货单查询", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.tbx_PlanId_Task.Focus();
}
else
{
DataSet set = new Sql2KDataAccess().Run_SqlText(this.SendResult + " Where PlanId='" + this.tbx_PlanId_Task.Text.Trim() + "' order by sendtime desc");
this.dgv_Send.DataSource = set.Tables[0];
this.lab_Total_Send.Text = "共查询到 " + set.Tables[0].Rows.Count.ToString() + " 条符合条件的记录";
}
}
