/// <summary>
/// 修改
/// </summary>
public override void EntityUpdate()
{
FormNoControlRule rule = new FormNoControlRule();
FormNoControl entity = EntityGet();
rule.RUpdate(entity);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
FormNoControlRule rule = new FormNoControlRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule frule = new FormNoControlRule();
txtFormNo.Text = frule.RGetFormNo((int)FormNoControlEnum.寄样编号);
if (this.FormListAID == 1)
{
txtFormNo.Text += "A";//LD
}
if (this.FormListAID == 2)
{
txtFormNo.Text += "B"; //S/O
}
if (this.FormListAID == 3)
{
txtFormNo.Text += "C";//临时
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
public override int EntityAdd()
{
FormNoControlRule rule = new FormNoControlRule();
FormNoControl entity = EntityGet();
rule.RAdd(entity);
return(entity.ID);
}
/// <summary>
/// 新增单据初始化控件数据(哪些值需要设置的设定一下)
/// </summary>
public override void IniInsertSet()
{
//生成报表文件名
FormNoControlRule rule = new FormNoControlRule();
//txtFileName.Text = rule.RGetFormNo("Data_ReportManage", "FileName") + ".fr3";
drpReportModelType.EditValue = "使用系统模板";
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.日常费用登记单号);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetFormNo("Chk_CheckOrder", "FormNo");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.资金计划表编号);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void txtFormNo_EditValueChanged(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.结算单号);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
//双击生成单号
private void txtCode_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule rule = new FormNoControlRule();
//txtCode.Text = rule.RGetFormNo((int)FormNoControlEnum.客户报价单号);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 单号自动生成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetWHFormNo(this.FormListAID, SysConvert.ToInt32(drpSubType.EditValue), "");
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void setItemNews(string p_Str)
{
string[] orderid = p_Str.Split(',');
for (int i = 0; i < orderid.Length; i++)
{
string sql = "SELECT * FROM UV1_Sale_SaleOrderDts WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[i]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
if (HTFormStatus == FormStatus.新增)
{
if (SysConvert.ToInt32(ProductParamSet.GetIntValueByID(6200)) == 2)//生产通知单单号启用新的生成规则：SR+年份+客户编码+01：SR14A00101
{
FormNoControlRule frule = new FormNoControlRule();
string vendorid = SysConvert.ToString(dt.Rows[0]["VendorID"]);
txtFormNo.Text = frule.RGetFormNo2((int)FormNoControlEnum.生产通知单号, vendorid);
}
}
gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["FK"]));
gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"]));
gridView1.SetRowCellValue(i, "SO", SysConvert.ToString(dt.Rows[0]["FormNo"]));
gridView1.SetRowCellValue(i, "SOQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]));
gridView1.SetRowCellValue(i, "LoadID", SysConvert.ToInt32(dt.Rows[0]["DtsID"]));
DateTime DtsReqDate = SysConvert.ToDateTime(dt.Rows[0]["DtsReqDate"]);
gridView1.SetRowCellValue(i, "ReqDate", DtsReqDate.AddDays(-2).Date);
drpSOTypeID.EditValue = SysConvert.ToInt32(dt.Rows[0]["OrderTypeID"]);
drpSaleOPID.EditValue = SysConvert.ToString(dt.Rows[0]["SaleOPID"]);
gridView1.SetRowCellValue(i, "MaxQty", SysConvert.ToString(dt.Rows[0]["MaxQty"]));
gridView1.SetRowCellValue(i, "MainQty", SysConvert.ToString(dt.Rows[0]["MinQty"]));
gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"]));
gridView1.SetRowCellValue(i, "VendorID", SysConvert.ToString(dt.Rows[0]["VendorID"]));
gridView1.SetRowCellValue(i, "OutRange", SysConvert.ToString(dt.Rows[0]["OutRange"]));
gridView1.SetRowCellValue(i, "VItemCode", SysConvert.ToString(dt.Rows[0]["VItemCode"]));
}
}
}
/// <summary>
/// 设置单号值
/// </summary>
/// <param name="p_Txt"></param>
/// <param name="p_CLSA"></param>
/// <param name="p_CLSB"></param>
/// <param name="p_SubTypeID"></param>
public static void FormNoIniSet(TextEdit p_Txt, string p_CLSA, string p_CLSB, int p_SubTypeID)
{
FNORelRule frule = new FNORelRule();
if (frule.RGetFormNoControlEditFlag(p_CLSA, p_CLSB, p_SubTypeID))//如果自行编辑
{
}
else//如果不自行编辑
{
FormNoControlRule rule = new FormNoControlRule();
string formcode = rule.RGetFormNo(p_CLSA, p_CLSB, p_SubTypeID);
if (formcode != string.Empty)
{
p_Txt.Text = formcode;
}
}
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule frule = new FormNoControlRule();
if (SysConvert.ToInt32(ProductParamSet.GetIntValueByID(6200)) == 2)//生产通知单单号启用新的生成规则：SR+年份+客户编码+01：SR14A00101
{
}
else
{
txtFormNo.Text = frule.RGetFormNo((int)FormNoControlEnum.生产通知单号);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增)
{
FormNoControlRule rule = new FormNoControlRule();
if (this.FormListAID == 3)//销售开票
{
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.发票单号);
}
else
{
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.发票单号2);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private ReportManage EntityGet()
{
ReportManage entity = new ReportManage();
entity.ID = HTDataID;
entity.SelectByID();
entity.ParentID = SysConvert.ToInt32(drpParentID.EditValue); //父节点ID
entity.MenuID = SysConvert.ToInt32(drpWinListID.EditValue); //菜单ID
entity.WinListID = SysConvert.ToInt32(txtWinListID.Text.Trim());
entity.WinID = SysConvert.ToInt32(txtWinID.Text.Trim()); //窗体ID Enum_WinForm
entity.Seq = SysConvert.ToInt32(txtSeq.Text.Trim());
entity.ReportName = txtReportName.Text.Trim();
entity.HeadTypeID = SysConvert.ToInt32(txtHeadTypeID.Text.Trim()); //窗体大类
entity.SubTypeID = SysConvert.ToInt32(txtSubTypeID.Text.Trim()); //窗体小类
entity.FileName = txtFileName.Text.Trim();
//if (saveFileID == 0)
if (entity.FileID == 0)
{
//生成报表文件名
FormNoControlRule rule = new FormNoControlRule();
entity.FileName = rule.RGetFormNo((int)FormNoControlEnum.报表流水号) + ".frx";
}
entity.ModelType = drpReportModelType.EditValue.ToString();
entity.ModelID = SysConvert.ToInt32(drpReportModel.EditValue);
entity.Url = "\\Report\\";
entity.Remark = txtRemark.Text.Trim();
entity.MDate = DateTime.Now;
entity.MUser = FParamConfig.LoginID;
OLDModelType = entity.ModelID.ToString();
return(entity);
}
/// <summary>
/// 双击生成快递单号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFormNo_DoubleClick(object sender, EventArgs e)
{
FormNoControlRule rule = new FormNoControlRule();
txtFormNo.Text = rule.RGetFormNo((int)FormNoControlEnum.快递单号);
}
