private void btnPrint()
{
try
{
if (chkAllow.Checked == false)
{
MessageBox.Show("请选择“允许送货”！");
return;
}
try
{
gridView1.FocusedRowHandle -= 1;
}
catch { }
DataTable dt = ((DataView)gridControl1.DataSource).Table;
RdInReport2 rep = new RdInReport2();
decimal dQTY = 0;
int iRow = 0;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["NowQty"].ToString().Trim() != "")
{
iRow += 1;
DataRow dr = rep.dataSet1.Tables[0].NewRow();
dr["Column1"] = dt.Rows[i]["cCode"].ToString().Trim();
dr["Column2"] = dt.Rows[i]["cInvCode"].ToString().Trim();
dr["Column3"] = dt.Rows[i]["cInvName"].ToString().Trim();
dr["Column4"] = dt.Rows[i]["cInvStd"].ToString().Trim();
dr["Column5"] = dt.Rows[i]["cInvm_unit"].ToString().Trim();
dr["Column6"] = dt.Rows[i]["cinva_unit"].ToString().Trim();
string s1 = "";
string s2 = "";
if (dt.Rows[i]["NowQty"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["NowQty"]) != 0)
{
dr["Column7"] = Convert.ToDecimal(dt.Rows[i]["NowQty"]);
s1 = dr["Column7"].ToString().Trim();
dQTY = dQTY + Convert.ToDecimal(dt.Rows[i]["NowQty"]);
}
if (dt.Rows[i]["NowNum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["NowNum"]) != 0)
{
dr["Column8"] = Convert.ToDecimal(dt.Rows[i]["NowNum"]);
s2 = dr["Column8"].ToString().Trim();
}
if (dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() == "1")
{
dr["Column9"] = "入 " + iRow;
}
if (dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() == "3")
{
dr["Column9"] = "到 " + iRow;
}
string sBarCode = dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() + "$" + FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName.Substring(7, 3).Trim() + "$" + dt.Rows[i]["modetailsid"].ToString().Trim() + "$" + s1 + "$" + s2;
dr["Column10"] = sBarCode;
if (dt.Rows[i]["cdefine36"].ToString().Trim() != "")
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["cdefine36"]).ToString("yyyy-MM-dd");
}
else if (dt.Rows[i]["cdefine37"].ToString().Trim() != "")
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["cdefine37"]).ToString("yyyy-MM-dd");
}
else
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["dDate"]).ToString("yyyy-MM-dd");
}
dr["Column12"] = dt.Rows[i]["iquantity"].ToString().Trim();
if (dt.Rows[i]["iNum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["iNum"]) != 0)
{
dr["Column13"] = dt.Rows[i]["iNum"].ToString().Trim();
}
dr["Column14"] = dt.Rows[i]["inqty"].ToString().Trim();
if (dt.Rows[i]["innum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["innum"]) != 0)
{
dr["Column15"] = dt.Rows[i]["innum"].ToString().Trim();
}
rep.dataSet1.Tables[0].Rows.Add(dr);
}
}
}
DataTable dt2 = rep.dataSet1.Tables[1];
DataRow dRowTe = dt2.NewRow();
dRowTe["Column1"] = rep.dataSet1.Tables[0].Rows.Count;
dRowTe["Column2"] = "供应商：" + txtVenName.Text.Trim();
dRowTe["Column3"] = "制单日期：" + DateTime.Parse(FrameBaseFunction.ClsBaseDataInfo.sLogDate).ToString("yyyy-MM-dd");
dRowTe["Column4"] = "制单人:" + FrameBaseFunction.ClsBaseDataInfo.sUserName;
dRowTe["Column5"] = "数量合计：" + dQTY.ToString().Trim();
dt2.Rows.Add(dRowTe);
rep.ShowPreview();
}
catch (Exception ee)
{
MessageBox.Show("加载打印失败! \n\n原因:\n " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUnAudit()
{
try
{
RdInReport2 rep = new RdInReport2();
try
{
gridView1.FocusedRowHandle -= 1;
}
catch { }
for (int i = 0; i < gridView1.RowCount; i++)
{
if (gridView1.GetRowCellValue(i, gridColumn16).ToString().Trim() == "" || Convert.ToDecimal(gridView1.GetRowCellValue(i, gridColumn16)) == 0)
{
continue;
}
DateTime d1 = DateTime.Now;
if (gridView1.GetRowCellValue(i, gridColumn23).ToString().Trim() != "")
{
d1 = Convert.ToDateTime(gridView1.GetRowCellValue(i, gridColumn23));
}
else if (gridView1.GetRowCellValue(i, gridColumn21).ToString().Trim() != "")
{
d1 = Convert.ToDateTime(gridView1.GetRowCellValue(i, gridColumn21));
}
DateTime d2 = DateTime.Today.AddDays(7);
if (d1 > d2)
{
throw new Exception("行" + (i + 1).ToString() + "提前7天，不能送货");
}
}
DataTable dt = ((DataView)gridControl1.DataSource).Table;
int iRow = 0;
decimal dQTY = 0;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["NowQty"].ToString().Trim() != "")
{
iRow += 1;
DataRow dr = rep.dataSet1.Tables[0].NewRow();
dr["Column1"] = dt.Rows[i]["cpoid"].ToString().Trim();
dr["Column2"] = dt.Rows[i]["cInvCode"].ToString().Trim();
dr["Column3"] = dt.Rows[i]["cInvName"].ToString().Trim();
dr["Column4"] = dt.Rows[i]["cInvStd"].ToString().Trim();
dr["Column5"] = dt.Rows[i]["cinvm_unit"].ToString().Trim();
dr["Column6"] = dt.Rows[i]["cInva_unit"].ToString().Trim();
string s1 = "";
string s2 = "";
if (dt.Rows[i]["NowQty"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["NowQty"]) != 0)
{
dr["Column7"] = Convert.ToDecimal(dt.Rows[i]["NowQty"]);
s1 = dr["Column7"].ToString().Trim();
dQTY = dQTY + Convert.ToDecimal(dt.Rows[i]["NowQty"]);
}
if (dt.Rows[i]["NowNum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["NowNum"]) != 0)
{
dr["Column8"] = Convert.ToDecimal(dt.Rows[i]["NowNum"]);
s2 = dr["Column8"].ToString().Trim();
}
if (dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() == "0")
{
dr["Column9"] = "入 " + iRow;
}
if (dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() == "2")
{
dr["Column9"] = "到 " + iRow;
}
string sBarCode = dt.Rows[i]["DType"].ToString().Trim().ToString().Trim() + "$200$" + dt.Rows[i]["id"].ToString().Trim() + "$" + s1 + "$" + s2;
dr["Column10"] = sBarCode;
if (dt.Rows[i]["cdefine36"].ToString().Trim() != "")
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["cdefine36"]).ToString("yyyy-MM-dd");
}
else if (dt.Rows[i]["cdefine37"].ToString().Trim() != "")
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["cdefine37"]).ToString("yyyy-MM-dd");
}
else
{
dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["dArriveDate"]).ToString("yyyy-MM-dd");
}
dr["Column12"] = dt.Rows[i]["iquantity"].ToString().Trim();
if (dt.Rows[i]["iNum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["iNum"]) != 0)
{
dr["Column13"] = dt.Rows[i]["iNum"].ToString().Trim();
}
dr["Column14"] = dt.Rows[i]["inqty"].ToString().Trim();
if (dt.Rows[i]["innum"].ToString().Trim() != "" && Convert.ToDecimal(dt.Rows[i]["innum"]) != 0)
{
dr["Column15"] = dt.Rows[i]["innum"].ToString().Trim();
}
rep.dataSet1.Tables[0].Rows.Add(dr);
}
}
DataTable dt2 = rep.dataSet1.Tables[1];
DataRow dRowTe = dt2.NewRow();
dRowTe["Column1"] = rep.dataSet1.Tables[0].Rows.Count;
dRowTe["Column2"] = "供应商：" + txtVenCode.Text.Trim() + "--" + txtVenName.Text.Trim();
dRowTe["Column3"] = "制单日期：" + DateTime.Parse(FrameBaseFunction.ClsBaseDataInfo.sLogDate).ToString("yyyy-MM-dd");
dRowTe["Column4"] = "制单人:" + FrameBaseFunction.ClsBaseDataInfo.sUserName;
dRowTe["Column5"] = "数量合计：" + dQTY.ToString().Trim();
dt2.Rows.Add(dRowTe);
rep.ShowPreview();
}
}
catch (Exception ee)
{
MessageBox.Show("加载打印失败! \n\n原因:\n " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//try
//{
// RdInReportLabel rep = new RdInReportLabel();
// try
// {
// gridView1.FocusedRowHandle -= 1;
// }
// catch { }
// DataTable dt = ((DataView)gridControl1.DataSource).Table;
// int iRow = 0;
// if (dt.Rows.Count > 0)
// {
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// if (dt.Rows[i]["NowQty"].ToString().Trim() != "")
// {
// iRow += 1;
// DataRow dr = rep.dataSet1.Tables[0].NewRow();
// dr["Column1"] = dt.Rows[i]["cpoid"].ToString().Trim();
// dr["Column2"] = dt.Rows[i]["cInvCode"].ToString().Trim();
// dr["Column3"] = dt.Rows[i]["cInvName"].ToString().Trim();
// dr["Column4"] = dt.Rows[i]["cInvStd"].ToString().Trim();
// dr["Column5"] = dt.Rows[i]["cinvm_unit"].ToString().Trim();
// dr["Column6"] = dt.Rows[i]["cInva_unit"].ToString().Trim();
// dr["Column7"] = dt.Rows[i]["NowQty"].ToString().Trim();
// dr["Column8"] = dt.Rows[i]["NowNum"].ToString().Trim();
// dr["Column9"] = iRow;
// string sBarCode = "0$" + FrameBaseFunction.ClsBaseDataInfo.sUFDataBaseName.Substring(7, 3).Trim() + "$" + dt.Rows[i]["id"].ToString().Trim() + "$" + dt.Rows[i]["nowqty"].ToString().Trim() + "$" + dt.Rows[i]["NowNum"].ToString().Trim();
// dr["Column10"] = sBarCode;
// dr["Column11"] = Convert.ToDateTime(dt.Rows[i]["dArriveDate"]).ToString("yyyy-MM-dd");
// rep.dataSet1.Tables[0].Rows.Add(dr);
// }
// }
// DataTable dt2 = rep.dataSet1.Tables[1];
// DataRow dRowTe = dt2.NewRow();
// dRowTe["Column1"] = rep.dataSet1.Tables[0].Rows.Count;
// dRowTe["Column2"] = "供应商：" + txtVenName.Text.Trim();
// dRowTe["Column3"] = "制单日期：" + DateTime.Parse(FrameBaseFunction.ClsBaseDataInfo.sLogDate).ToString("yyyy-MM-dd");
// dRowTe["Column4"] = "制单人:" + FrameBaseFunction.ClsBaseDataInfo.sUserName;
// dt2.Rows.Add(dRowTe);
// rep.ShowPreview();
// }
//}
//catch (Exception ee)
//{
// MessageBox.Show("加载打印失败! \n\n原因:\n " + ee.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
