/// <summary>
/// 处理使用状态名称(染色合同)
/// </summary>
/// <param name="p_Dt">数据表</param>
public static void ProcColorUseStatusName(DataTable p_Dt, string p_YarnFinishName, int p_MaxDayNum)
{
decimal qty = 0;
decimal leaveqty = 0;
string sql = string.Empty;
string statusname = string.Empty;
DateTime dtInTime;
DataTable dt;
foreach (DataRow dr in p_Dt.Rows)
{
if (p_YarnFinishName == dr["YarnStatusName"].ToString()) //已经完成了才处理相关状态
{
dtInTime = DateTime.Now.Date;
leaveqty = 0;
qty = SysConvert.ToDecimal(dr["HaveInQty"].ToString()); //已入库
sql = "SELECT InDate,Qty FROM WH_Storge WHERE DtsSO=" + SysString.ToDBString(dr["CompactCode"].ToString()) + " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString());
dt = SysUtils.Fill(sql);
foreach (DataRow drStorge in dt.Rows)
{
dtInTime = SysConvert.ToDateTime(drStorge["InDate"]);
leaveqty += SysConvert.ToDecimal(drStorge["Qty"]);
}
dr["LeaveQty"] = leaveqty;
if (leaveqty >= qty * 0.1m) //库存剩余超过10%
{
if (dtInTime.AddDays(p_MaxDayNum) <= DateTime.Now.Date) //超过限制的天数了
{
statusname = ColorStatusName[1];
}
else //否则正常
{
statusname = ColorStatusName[0];
}
}
else //状态 已使用
{
statusname = ColorStatusName[2];
}
}
else //正常
{
statusname = ColorStatusName[0];
}
dr["UseStatusName"] = statusname;
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
TestReportDts MasterEntity = (TestReportDts)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO WO_TestReportDts(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("MainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ",");
MasterField.Append("Seq" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ",");
MasterField.Append("TProject" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.TProject) + ",");
MasterField.Append("EvaluationGrade" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.EvaluationGrade) + ",");
MasterField.Append("Remark" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ItemPic MasterEntity = (ItemPic)p_Entity;
if (MasterEntity.MainID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Data_ItemPic(");
MasterValue.Append(" VALUES(");
MasterField.Append("MainID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID) + ",");
MasterField.Append("Seq" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq) + ",");
MasterField.Append("PicImage" + ",");
MasterValue.Append(@"@PicImage" + ",");
MasterField.Append("Remark" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ")");
object[,] obja = new object[2, 1];
obja[0, 0] = "@PicImage";
obja[1, 0] = MasterEntity.PicImage;
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString(), obja);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
AddressList MasterEntity = (AddressList)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Data_AddressList(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("DVendorID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DVendorID) + ",");
MasterField.Append("DVendorAttn" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DVendorAttn) + ",");
MasterField.Append("DVendorName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DVendorName) + ",");
MasterField.Append("DelFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ",");
MasterField.Append("SubmitFlag" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//提交动作
this.m_strSubmitAction = ProcessConstString.SubmitAction.ACTION_SUBMIT;
switch (base.StepName)
{
case ProcessConstString.StepName.ReceiveStepName.STEP_PLOT:
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsDeny, false);
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsPlot, false);
ViewBase l_objClerks = OAUser.GetUserByRole(OUConstString.RoleName.PartysDocument);
String l_strClerkField = String.Empty;
foreach (User user in l_objClerks.Ens)
{
l_strClerkField += user.DomainUserID + ";";
}
l_strClerkField = SysString.TrimLastWord(l_strClerkField);
l_htAttribute.Add(ConstString.CustomAttr.Receive.Clerks, l_strClerkField);
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_INSTRUCTION:
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_PROCESS_CENTER:
//l_htAttribute.Add(ConstString.CustomAttr.Receive.IsPlot, false);
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsAssignSection, false);
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsAssignPeople, false);
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsDirectArchive, true);
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_SECTION_MEMBER:
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_SECTION_CHIEF:
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsAssignSection, false);
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_SECTION_DIRECTOR:
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsAssignSection, false);
l_htAttribute.Add(ConstString.CustomAttr.Receive.IsAssignPeople, false);
break;
case ProcessConstString.StepName.ReceiveStepName.STEP_DISTRIBUTION:
break;
default:
break;
}
base.FormSubmit(false, m_strSubmitAction, l_htAttribute, this.ControlToEntity(false));
}
protected void btnSumitInspect_Click(object sender, EventArgs e)
{
B_ReceiveEdit l_BusReceiveEdit = null;
String l_strInspector = String.Empty;
if (String.IsNullOrEmpty(ddlPoliticalOfficer.SelectedValue))
{
JScript.ShowMsgBox(this.Page, MsgType.VbCritical, "没有选择党群工作处处长");
return;
}
l_strInspector = ddlPoliticalOfficer.SelectedValue;
//表单的合法性验证
if (!VerifyField())
{
JScript.ShowMsgBox(Page, MsgType.VbCritical, m_strAryMessages);
return;
}
//提交动作
this.m_strSubmitAction = ProcessConstString.SubmitAction.ReceiveBase.SUBMIT_INSPECT;
if (String.IsNullOrEmpty(WorkItemID))
{
//流程创建时候设置自定义属性
l_htAttribute.Add(ConstString.CustomAttr.Receive.Initiator, CurrentUserInfo.UserName);
l_BusReceiveEdit = new B_ReceiveEdit();
l_BusReceiveEdit.ID = Convert.ToInt32(this.RegisterID);
if (l_BusReceiveEdit != null)
{
l_BusReceiveEdit.ProcessID = base.ProcessID;
l_BusReceiveEdit.Save();
}
}
ViewBase l_objClerks = OAUser.GetUserByRole(OUConstString.RoleName.PartysDocument);
String l_strClerkField = String.Empty;
foreach (User user in l_objClerks.Ens)
{
l_strClerkField += user.DomainUserID + ";";
}
l_strClerkField = SysString.TrimLastWord(l_strClerkField);
l_htAttribute.Add(ConstString.CustomAttr.Receive.Officer, l_strInspector);
l_htAttribute.Add(ConstString.CustomAttr.Receive.Clerks, l_strClerkField);
base.FormSubmit(false, m_strSubmitAction, l_htAttribute, this.ControlToEntity(false));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
WHCalMethod MasterEntity = (WHCalMethod)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Enum_WHCalMethod(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("Code" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Code) + ",");
MasterField.Append("Name" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Name) + ",");
MasterField.Append("Remark" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ",");
MasterField.Append("FieldName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FieldName) + ",");
MasterField.Append("DelFlag" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnLoad_Click(object sender, EventArgs e)
{
try
{
//if (SysConvert.ToString(drpVendorID.EditValue) == string.Empty)
//{
// this.ShowMessage("请选择收货单位");
// drpVendorID.Focus();
// return;
//}
frmLoadFHForm frm = new frmLoadFHForm();
frm.WL = true;
string sql = string.Empty;
sql += " AND SendCode+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(SendNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_Attn_GoodsTransDts";
if (saveNoLoadCheckDayNum != 0)
{
sql += " WHERE MakeDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
}
sql += ")";
sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(SendNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_Attn_GoodsTransDts";
if (saveNoLoadCheckDayNum != 0)
{
sql += " WHERE MakeDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
}
sql += ")";
frm.NoLoadCondition = sql;
//frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
frm.ShowDialog();
string str = string.Empty;
if (frm.FHFormID != null && frm.FHFormID.Length != 0)
{
SetGridView1();
for (int i = 0; i < frm.FHFormID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.FHFormID[i]);
}
setItemNews(str);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void gridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "SBitID")
{
string SBitID = SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "SBitID"));
string sql = "SELECT * FROM WH_SBit WHERE SBitID =" + SysString.ToDBString(SBitID);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
gridView1.SetRowCellValue(e.RowHandle, "WHID", SysConvert.ToString(dt.Rows[0]["WHID"]));
gridView1.SetRowCellValue(e.RowHandle, "SectionID", SysConvert.ToString(dt.Rows[0]["SectionID"]));
}
}
}
private void BindGrid()
{
string sql = "SELECT * FROM Sale_SaleOrderCapDts WHERE MainID=" + SysString.ToDBString(m_ID);
DataTable dt = SysUtils.Fill(sql);
int count = dt.Rows.Count;
for (int i = 0; i < 5 - count; i++)
{
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 根据条码得到图片
/// </summary>
/// <param name="p_Code"></param>
/// <returns></returns>
private byte[] GetPic(string p_Code)
{
string sql = "SELECT GBPic FROM Data_ItemGB WHERE GBCode=" + SysString.ToDBString(p_Code);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
return((byte[])dt.Rows[0]["GBPic"]);
}
else
{
return(null);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
string sql = " AND ItemTypeID=" + SysString.ToDBString(m_ItemType);
if (ItemClassArray != "-1" && ItemClassArray != "")
{
sql += " AND ItemClassID IN(" + ItemClassArray + ")";
}
StorgeRule rule = new StorgeRule();
gridView1.GridControl.DataSource = rule.RShow(sql + HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtFormNo.Text.Trim() != "")
{
tempStr += " AND FormNo LIKE " + SysString.ToDBString("%" + txtFormNo.Text.Trim() + "%");
}
if (chkQMakeDate.Checked)
{
tempStr += " AND FormDate BETWEEN " + SysString.ToDBString(txtQMakeDateB.DateTime) + " AND " + SysString.ToDBString(txtQMakeDateE.DateTime);
}
if (SysConvert.ToString(drpSaleOPID.EditValue) != "")
{
tempStr += " AND SaleOPID=" + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue));
}
if (SysConvert.ToString(drpTrackOPID.EditValue) != "")
{
tempStr += " AND TrackOPID=" + SysString.ToDBString(SysConvert.ToString(drpTrackOPID.EditValue));
}
if (txtItemCode.Text.Trim() != "")
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtItemModel.Text.Trim() != "")
{
tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.Text.Trim() + "%");
}
if (txtColorName.Text.Trim() != "")
{
tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtColorName.Text.Trim() + "%");
}
if (txtFlower.Text.Trim() != "")
{
tempStr += " AND Flower LIKE " + SysString.ToDBString("%" + txtFlower.Text.Trim() + "%");
}
if (ID > 0)
{
tempStr += " AND MainID=" + SysString.ToDBString(ID);
}
HTDataConditionStr = tempStr;
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtCode.Text.Trim() != "")
{
tempStr += " AND Code LIKE" + SysString.ToDBString("%" + txtCode.Text.Trim() + "%");
}
if (txtName.Text.Trim() != "")
{
tempStr += " AND Name LIKE" + SysString.ToDBString("%" + txtName.Text.Trim() + "%");
}
HTDataConditionStr = tempStr;
}
private string GetCSItem(int p_CSID)
{
string sql = "SELECT Name FROM Data_CSBGItem WHERE ID=" + SysString.ToDBString(p_CSID);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
return(SysConvert.ToString(dt.Rows[0][0]));
}
else
{
return("");
}
}
/// <summary>
/// 获得查询条件
/// </summary>
private void GetCondition2()
{
string outstr = string.Empty;
if (saveWHID == string.Empty)
{
outstr += " AND WHID IN(SELECT WHID FROM WH_WH WHERE WHTypeID=" + saveWHTypeID + ")";
}
else
{
outstr += " AND WHID=" + SysString.ToDBString(saveWHID);
}
conditionstr2 = outstr;
}
private void GetItemLabel(string GBCode)
{
string sql = "SELECT * FROM UV1_Data_ItemGB WHERE GBCode=" + SysString.ToDBString(GBCode);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
lbItemCode.Text = SysConvert.ToString(dt.Rows[0]["ItemCode"]);
lbGoodsCode.Text = SysConvert.ToString(dt.Rows[0]["GoodsCode"]);
lbVendorID.Text = SysConvert.ToString(dt.Rows[0]["VendorID"]);
lbColorNum.Text = SysConvert.ToString(dt.Rows[0]["ColorNum"]);
lbColorName.Text = SysConvert.ToString(dt.Rows[0]["ColorName"]);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ItemBaseCheckItem MasterEntity = (ItemBaseCheckItem)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Data_ItemBaseCheckItem(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("Code" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Code) + ",");
MasterField.Append("Name" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Name) + ",");
MasterField.Append("CLSA" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CLSA) + ",");
MasterField.Append("CLSB" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.CLSB) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
ItemAdd MasterEntity = (ItemAdd)p_Entity;
if (MasterEntity.MainID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Data_ItemAdd SET ");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" Name=" + SysString.ToDBString(MasterEntity.Name) + ",");
UpdateBuilder.Append(" FiledName=" + SysString.ToDBString(MasterEntity.FiledName) + ",");
UpdateBuilder.Append(" Value=" + SysString.ToDBString(MasterEntity.Value) + ",");
UpdateBuilder.Append(" DRemark=" + SysString.ToDBString(MasterEntity.DRemark) + ",");
UpdateBuilder.Append(" FiledSetID=" + SysString.ToDBString(MasterEntity.FiledSetID) + ",");
UpdateBuilder.Append(" FormID=" + SysString.ToDBString(MasterEntity.FormID) + ",");
UpdateBuilder.Append(" FormAID=" + SysString.ToDBString(MasterEntity.FormAID) + ",");
UpdateBuilder.Append(" FormBID=" + SysString.ToDBString(MasterEntity.FormBID));
UpdateBuilder.Append(" WHERE " + "MainID=" + SysString.ToDBString(MasterEntity.MainID) + " AND Seq=" + SysString.ToDBString(MasterEntity.Seq));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
/// <summary>
/// 脚本回传
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOK_Click(object sender, EventArgs e)
{
String strIds = String.Empty;
String strNos = String.Empty;
String strNames = String.Empty;
//if (UCIsSingle)
//{
// strIds = this.gvCompany.SelectedKey;
//}
//else
//{
//strIds = SysString.GetStringFormatForList(this.gvCompany.SelectedKeys, ",");
strNames = SysString.GetStringFormatForList(this.msExoticCompanyList.SelectedValues, ";");
//}
//vb = OADept.GetCompany(this.ddlType.SelectedIndex + 1, this.txtSearchText.Text.Trim());
//if (String.IsNullOrEmpty(strIds) == false)
//{
// if (vb != null)
// {
// vb.Condition = "a.ID in (" + strIds + ")";
// strIds = vb.GetFieldVals("ID", ";");
// strNos = vb.GetFieldVals("No", ";");
// strNames = vb.GetFieldVals("Name", ";");
// }
//}
String strScript = String.Empty;
//if (this.UCIDControl != String.Empty)
//{
// strScript += base.GetJSscriptValue(this.UCIDControl, strIds);
//}
//if (this.UCNoControl != String.Empty)
//{
// strScript += base.GetJSscriptValue(this.UCNoControl, strNos);
// strScript += base.GetJSscriptTitle(this.UCNoControl, strNames);
//}
if (this.UCNameControl != String.Empty)
{
strScript += base.GetJSscriptValue(this.UCNameControl, strNames);
strScript += base.GetJSscriptTitle(this.UCNameControl, strNos);
}
strScript += String.Format("parent.ClosePopDiv('{0}')", base.divPopDivID + base.UCID);
//组成一整条js后运行
ClientScriptM.ResponseScript(this, strScript);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
SaleProcedure MasterEntity = (SaleProcedure)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Enum_SaleProcedure SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" Code=" + SysString.ToDBString(MasterEntity.Code) + ",");
UpdateBuilder.Append(" Name=" + SysString.ToDBString(MasterEntity.Name) + ",");
UpdateBuilder.Append(" ShowFlag=" + SysString.ToDBString(MasterEntity.ShowFlag) + ",");
UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ",");
UpdateBuilder.Append(" JGUseFlag=" + SysString.ToDBString(MasterEntity.JGUseFlag) + ",");
UpdateBuilder.Append(" JGItemTypeID=" + SysString.ToDBString(MasterEntity.JGItemTypeID) + ",");
UpdateBuilder.Append(" JGWHIDDefault=" + SysString.ToDBString(MasterEntity.JGWHIDDefault) + ",");
UpdateBuilder.Append(" JGFormListID=" + SysString.ToDBString(MasterEntity.JGFormListID) + ",");
UpdateBuilder.Append(" PackCheckFlag=" + SysString.ToDBString(MasterEntity.PackCheckFlag));
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
/// <summary>
/// 更新表单设置的值
/// </summary>
/// <param name="p_ID"></param>
/// <param name="p_TableName"></param>
/// <param name="p_FiledName"></param>
/// <param name="p_Value"></param>
/// <param name="sqlTrans"></param>
public void UpdateFiledSet(int p_ID, int p_FiledSetID, string p_Value, IDBTransAccess sqlTrans)
{
try
{
FiledSet entity = new FiledSet(sqlTrans);
entity.ID = p_FiledSetID;
entity.SelectByID();
string sql = "";
if (entity.UpDateFlag == 1) //更新标志
{
if (entity.FiledType == "string")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToString(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "decimal")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDecimal(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "int")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToInt32(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "datetime")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDateTime(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 查询条件
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtVendorID.Text.Trim() != "")
{
tempStr += " AND VendorID LIKE " + SysString.ToDBString("%" + txtVendorID.Text.Trim() + "%");
}
if (txtGoodsCode.Text.Trim() != "")
{
tempStr += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%");
}
if (txtColorNum.Text.Trim() != "")
{
tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtColorNum.Text.Trim() + "%");
}
if (txtItemCode.Text.Trim() != "")
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtMLDL.Text.Trim() != "")
{
tempStr += " AND MLDLCode LIKE " + SysString.ToDBString("%" + txtMLDL.Text.Trim() + "%");
}
if (txtMLLB.Text.Trim() != "")
{
tempStr += " AND MLLBCode LIKE " + SysString.ToDBString("%" + txtMLLB.Text.Trim() + "%");
}
if (txtItemName.Text.Trim() != "")
{
tempStr += " AND ItemName LIKE " + SysString.ToDBString("%" + txtItemName.Text.Trim() + "%");
}
if (txtMWeightS.Text.Trim() != "")
{
tempStr += " AND MWeight> " + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightS.Text.Trim()));
}
if (txtMWeightE.Text.Trim() != "")
{
tempStr += " AND MWeight< " + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightE.Text.Trim()));
}
if (txtGBCode.Text.Trim() != "")
{
tempStr += " AND GBCode LIKE " + SysString.ToDBString("%" + txtGBCode.Text.Trim() + "%");
}
tempStr += " AND UseableFlag=1";
tempStr += " ORDER BY GBDate DESC";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
ReportManageDts MasterEntity = (ReportManageDts)p_Entity;
if (MasterEntity.MainID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Data_ReportManageDts SET ");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" DataSourceName=" + SysString.ToDBString(MasterEntity.DataSourceName) + ",");
UpdateBuilder.Append(" SqlName=" + SysString.ToDBString(MasterEntity.SqlName) + ",");
UpdateBuilder.Append(" SqlStr=" + SysString.ToDBString(MasterEntity.SqlStr) + ",");
UpdateBuilder.Append(" QueryName=" + SysString.ToDBString(MasterEntity.QueryName) + ",");
UpdateBuilder.Append(" OrderCondition=" + SysString.ToDBString(MasterEntity.OrderCondition) + ",");
UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ",");
UpdateBuilder.Append(" SqlFlag=" + SysString.ToDBString(MasterEntity.SqlFlag) + ",");
UpdateBuilder.Append(" SourceType=" + SysString.ToDBString(MasterEntity.SourceType));
UpdateBuilder.Append(" WHERE " + "MainID=" + SysString.ToDBString(MasterEntity.MainID) + " AND Seq=" + SysString.ToDBString(MasterEntity.Seq));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)EnumMessage.CommonDBUpdate), E);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
string sql = " AND ItemTypeID=" + SysString.ToDBString((int)EnumItemType.面料);
if (ItemClassArray != "-1" && ItemClassArray != "")
{
sql += " AND ItemClassID IN(" + ItemClassArray + ")";
}
ItemRule rule = new ItemRule();
DataTable dt = rule.RShow(sql + HTDataConditionStr + " ORDER BY ItemCode DESC", ProcessGrid.GetQueryField(gridView1).Replace(",GBPic2", ""));//GBPic2 重新单独处理获得;
BindProcPicture(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtVendorID.Text.Trim() != "")
{
tempStr += " AND DVendorID LIKE " + SysString.ToDBString("%" + txtVendorID.Text.Trim() + "%");
}
if (SysConvert.ToInt32(drpDHID.EditValue) != 0)
{
tempStr += " AND DataDHID=" + SysString.ToDBString(SysConvert.ToInt32(drpDHID.EditValue));
}
HTDataConditionStr = tempStr;
}
/// <summary>
/// 绑定仓库位
/// </summary>
private void BindGridSBit()
{
if (gridView1.RowCount > 0)
{
SBitRule rule = new SBitRule();
string Str = string.Empty;
Str = " AND WHID=" + SysString.ToDBString(txtWHID.Text.Trim());
Str += " AND SectionID=" + SysString.ToDBString(SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID")));
gridView3.GridControl.DataSource = rule.RShow(Str, ProcessGrid.GetQueryField(gridView3));
gridView3.GridControl.Show();
txtWHIDBit.Text = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "WHID"));
txtSectionIDBit.Text = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID"));
}
}
/// <summary>
/// 根据FormListAID得到顶层单据类型入库、出库、盘点、移库、形态转换、期初入库
/// </summary>
/// <param name="p_FormListAID">loginID</param>
/// <returns></returns>
public static int GetFormListTopTypeByFormListID(int p_FormListAID, IDBTransAccess sqlTrans)
{
int outint = p_FormListAID;
string sql = "SELECT ParentID FROM Enum_FormList WHERE ID=" + SysString.ToDBString(p_FormListAID);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
if (SysConvert.ToInt32(dt.Rows[0]["ParentID"]) != 0)
{
outint = SysConvert.ToInt32(dt.Rows[0]["ParentID"]);
}
}
return(outint);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ItemGYFlowDts MasterEntity=(ItemGYFlowDts)p_Entity;
if (MasterEntity.ID==0)
{
return 0;
}
//新增主表数据
StringBuilder MasterField=new StringBuilder();
StringBuilder MasterValue=new StringBuilder();
MasterField.Append("INSERT INTO Data_ItemGYFlowDts(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID)+",");
MasterField.Append("MainID"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MainID)+",");
MasterField.Append("Seq"+",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Seq)+",");
MasterField.Append("ItemGYTypeID"+")");
MasterValue.Append(SysString.ToDBString(MasterEntity.ItemGYTypeID)+")");
//执行
int AffectedRows=0;
if(!this.sqlTransFlag)
{
AffectedRows=this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows=sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return AffectedRows;
}
catch(BaseException E)
{
throw new BaseException(E.Message,E);
}
catch(Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert),E);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
VendorInvoiceDts MasterEntity = (VendorInvoiceDts)p_Entity;
if (MasterEntity.MainID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Data_VendorInvoiceDts SET ");
UpdateBuilder.Append(" MainID=" + SysString.ToDBString(MasterEntity.MainID) + ",");
UpdateBuilder.Append(" Seq=" + SysString.ToDBString(MasterEntity.Seq) + ",");
UpdateBuilder.Append(" CompName=" + SysString.ToDBString(MasterEntity.CompName) + ",");
UpdateBuilder.Append(" TaxNo=" + SysString.ToDBString(MasterEntity.TaxNo) + ",");
UpdateBuilder.Append(" Address=" + SysString.ToDBString(MasterEntity.Address) + ",");
UpdateBuilder.Append(" Tel=" + SysString.ToDBString(MasterEntity.Tel) + ",");
UpdateBuilder.Append(" Bank=" + SysString.ToDBString(MasterEntity.Bank) + ",");
UpdateBuilder.Append(" No=" + SysString.ToDBString(MasterEntity.No) + ",");
UpdateBuilder.Append(" DRemark=" + SysString.ToDBString(MasterEntity.DRemark));
UpdateBuilder.Append(" WHERE " + "MainID=" + SysString.ToDBString(MasterEntity.MainID) + " AND Seq=" + SysString.ToDBString(MasterEntity.Seq));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}