/// <summary>
/// 获取滚动图片信息
/// </summary>
/// <param name="sType">类型</param>
/// <returns></returns>
public DataSet getQuesByTime(string sType, string sLastTime)
{
DataSet dst = null;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" select * ");
sb.Append(" from td_question ");
sb.Append(" WHERE 1 = 1 ");
sb.Append(" AND q_type = ?q_type ");
sb.Append(" AND create_time >= ?create_time ");
sb.Append(" order by create_time ");
m_dbo.AddParameter("q_type", sType);
m_dbo.AddParameter("create_time", sLastTime);
try
{
dst = this.m_dbo.Select(CConvert.ToString(sb));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(dst);
}
private void FrmProductGroupDialog_Load(object sender, EventArgs e)
{
if (_currentProductGroupTable != null)
{
txtCode.Text = _currentProductGroupTable.CODE;
txtName.Text = _currentProductGroupTable.NAME;
txtParentCode.Text = _currentProductGroupTable.PARENT_CODE;
txtParentName.Text = _currentProductGroupTable.PARENT_NAME;
txtIndicatesOrder.Text = CConvert.ToString(_currentProductGroupTable.INDICATES_ORDER);
}
if (_mode == CConstant.MODE_NEW)
{
this.Text = "新建";
}
else if (_mode == CConstant.MODE_MODIFY)
{
this.Text = "编辑";
txtCode.BackColor = Color.WhiteSmoke;
txtCode.Enabled = false;
}
else if (_mode == CConstant.MODE_COPY)
{
this.Text = "新建";
txtCode.Text = "";
}
}
private void txtSupplierCode_Leave(object sender, EventArgs e)
{
string SupplierCode = txtSupplierCode.Text.Trim();
if (!string.IsNullOrEmpty(SupplierCode))
{
BaseMaster baseMaster = bCommon.GetBaseMaster("SUPPLIER", SupplierCode);
if (baseMaster != null)
{
txtSupplierCode.Text = baseMaster.Code;
txtSupplierName.Text = baseMaster.Name;
txtBalance.Text = CConvert.ToString(GetSupplierDepositBlanace(txtSupplierCode.Text.Trim()));
}
else
{
MessageBox.Show("供应商编号不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtSupplierCode.Text = "";
txtSupplierName.Text = "";
txtBalance.Text = "";
txtSupplierCode.Focus();
}
}
else
{
txtSupplierName.Text = "";
txtBalance.Text = "";
}
}
/// <summary>
/// 采购清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPurchaseList_Click(object sender, EventArgs e)
{
string slipNumbers = "";
foreach (DataGridViewRow dr in dgvData.Rows)
{
if (CConvert.ToBoolean(dr.Cells["CHK"].Value))
{
slipNumbers = CConvert.ToString(dr.Cells["SLIP_NUMBER"].Value) + ",";
}
}
if (slipNumbers.Length > 0)
{
slipNumbers = slipNumbers.Substring(0, slipNumbers.Length - 1);
}
else
{
MessageBox.Show("请先选择订单。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "HD_PURCHASE_PLAN_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
if (sf.ShowDialog(this) == DialogResult.OK)
{
}
}
/// <summary>
/// 保存
/// </summary>
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
if (_currentUserTable == null)
{
_currentUserTable = new BaseUserTable();
}
_currentUserTable.CODE = (txtCompanyCode.Text + txtCode.Text.Trim());
_currentUserTable.NAME = txtName.Text;
_currentUserTable.PASSWORD = DESEncrypt.Encrypt(txtPassword.Text);
_currentUserTable.PHONE = txtPhone.Text;
_currentUserTable.EMAIL = txtEmail.Text;
_currentUserTable.DEPARTMENT_CODE = txtDepartmentCode.Text;
_currentUserTable.COMPANY_CODE = txtCompanyCode.Text;
_currentUserTable.ROLES_CODE = txtRolesCode.Text;
//_currentUserTable.PHOTO = GetImageToByte(txtPhoto.Text);
_currentUserTable.PHOTO = null;
_currentUserTable.LAST_UPDATE_USER = _userInfo.CODE;
if (txtIntCommunityDate.Checked == true)
{
_currentUserTable.INT_COMMUNITY_DATE = CConvert.ToDateTime(txtIntCommunityDate.Text);
}
else
{
_currentUserTable.INT_COMMUNITY_DATE = null;
}
if (txtOutCommunityDate.Checked == true)
{
_currentUserTable.OUT_COMMUNITY_DATE = CConvert.ToDateTime(txtOutCommunityDate.Text);
}
else
{
_currentUserTable.OUT_COMMUNITY_DATE = null;
}
try
{
if (bUser.Exists(_currentUserTable.CODE, _currentUserTable.COMPANY_CODE))
{
bUser.Update(_currentUserTable);
}
else
{
_currentUserTable.CREATE_USER = _userInfo.CODE;
bUser.Add(_currentUserTable);
}
}
catch (Exception ex)
{
//log.error
MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
result = DialogResult.OK;
this.Close();
}
/// <summary>
/// 用户权限变更后我的桌面重置处理
/// </summary>
public void ReSetMyDesk(string companyCode, string userCode, string rolesCode)
{
//当前角色的所有权限
DataTable rolesDt = GetRoles(rolesCode).Tables[0];
//当前用户的桌面
DataTable deskDt = GetDeskDatas(companyCode, userCode).Tables[0];
foreach (DataRow deskRow in deskDt.Rows)
{
bool isExist = false;
foreach (DataRow rolesRow in rolesDt.Rows)
{
if (CConvert.ToString(deskRow["FORM_NAME"]).Equals(CConvert.ToString(rolesRow["CLASS_NAME"])) && CConvert.ToString(deskRow["FORM_ARGS"]).Equals(CConvert.ToString(rolesRow["TAG"])))
{
isExist = true;
}
}
if (!isExist)
{
//删除当前桌面应用
BaseDeskTable deskTable = new BaseDeskTable();
deskTable.COMPANY_CODE = CConvert.ToString(deskRow["COMPANY_CODE"]);
deskTable.USER_CODE = CConvert.ToString(deskRow["USER_CODE"]);
deskTable.FORM_NAME = CConvert.ToString(deskRow["FORM_NAME"]);
deskTable.FORM_TITLE = CConvert.ToString(deskRow["FORM_TITLE"]);
deskTable.FORM_ARGS = CConvert.ToString(deskRow["FORM_ARGS"]);
DeleteDesk(deskTable);
}
}
}
/// <summary>
/// 数据保存前明细数据验证
/// </summary>
private bool CheckLineInput()
{
if (dgvData.Rows.Count == 0)
{
MessageBox.Show("明细数不能为空。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
foreach (DataGridViewRow row in dgvData.Rows)
{
if (CConvert.ToString(row.Cells["PRODUCT_CODE"].Value) == "")
{
MessageBox.Show("商品编号不能为空。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
else if (CConvert.ToString(row.Cells["QUANTITY"].Value) == "")
{
MessageBox.Show("采购数量不能为空。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
else if (CConvert.ToDecimal(row.Cells["QUANTITY"].Value) == 0)
{
MessageBox.Show("采购数量不能为零。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
else if (CConvert.ToString(row.Cells["PRICE"].Value) == "")
{
MessageBox.Show("采购单价不能为空。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
return(true);
}
/// <summary>
/// 获取新闻明细
/// </summary>
/// <param name="sNickName">昵称</param>
/// <param name="sQQ">QQ</param>
/// <param name="sTel">电话</param>
/// <param name="sContent">内容</param>
/// <returns></returns>
public int CreateQA(string sNickName, string sQQ, string sTel, string sContent)
{
StringBuilder sb = new StringBuilder();
sb.Append(" insert into td_qa(nickname,tel,qq,problem,reply,time,isreply,state)values( ");
sb.Append(" ?nickname,?tel,?qq,?problem,'',now(),'0','0') ");
try
{
m_dbo.RemoveAllParameters();
m_dbo.AddParameter("nickname", sNickName);
m_dbo.AddParameter("qq", sQQ);
m_dbo.AddParameter("tel", sTel);
m_dbo.AddParameter("problem", sContent);
return(this.m_dbo.ExecuteSQL(CConvert.ToString(sb)));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
}
private void txtCustomerCode_Leave(object sender, EventArgs e)
{
string customerCode = txtCustomerCode.Text.Trim();
if (customerCode != "")
{
BaseMaster baseMaster = bCommon.GetBaseMaster("CUSTOMER", customerCode);
if (baseMaster != null)
{
txtCustomerCode.Text = baseMaster.Code;
txtCustomerName.Text = baseMaster.Name;
}
else
{
MessageBox.Show("客户不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtCustomerCode.Text = "";
txtCustomerName.Text = "";
txtCustomerCode.Focus();
}
}
else
{
txtCustomerName.Text = "";
}
txtBalance.Text = CConvert.ToString(GetCustomerDepositBlanace(txtCustomerCode.Text.Trim()));
}
/// <summary>
/// 获取成果明细
/// </summary>
/// <param name="sId">成果ID</param>
/// <returns></returns>
public DataSet getVercodeInfoByCode(string sId)
{
DataSet dst = null;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" select * ");
sb.Append(" from td_license ");
sb.Append(" WHERE 1 = 1 ");
sb.Append(" AND code = ?id ");
try
{
m_dbo.AddParameter("id", sId);
dst = this.m_dbo.Select(CConvert.ToString(sb));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(dst);
}
/// <summary>
/// 获取成果明细
/// </summary>
/// <param name="sId">成果ID</param>
/// <returns></returns>
public DataSet GetAllAchievement()
{
DataSet dst = null;
StringBuilder sb = new StringBuilder();
sb.Append(" select * ");
sb.Append(" from td_achievements ");
sb.Append(" WHERE 1 = 1 ");
sb.Append(" ORDER BY time desc ");
try
{
dst = this.m_dbo.Select(CConvert.ToString(sb));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(dst);
}
public int RemoveQuestion(string sId)
{
int iRet = 0;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" Delete from td_question ");
sb.Append(" where ");
sb.Append(" q_id=?id ");
try
{
m_dbo.RemoveAllParameters();
m_dbo.AddParameter("id", sId);
iRet += this.m_dbo.ExecuteSQL(CConvert.ToString(sb));
}
catch (Exception e)
{
iRet = -1;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(iRet);
}
/// <summary>
/// 获取成果明细
/// </summary>
/// <param name="sId">成果ID</param>
/// <returns></returns>
public DataSet GetAchievementById(string sId)
{
DataSet dst = null;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" select * ");
sb.Append(" from td_achievements ");
sb.Append(" WHERE 1 = 1 ");
sb.Append(" AND id = ?id ");
try
{
m_dbo.AddParameter("id", sId);
dst = this.m_dbo.Select(CConvert.ToString(sb));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(dst);
}
/// <summary>
/// 获取滚动图片信息
/// </summary>
/// <param name="sType">类型</param>
/// <returns></returns>
public DataSet GetAllCarousel(string sType)
{
DataSet dst = null;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" select * ");
sb.Append(" from td_anima ");
sb.Append(" WHERE 1 = 1 ");
sb.Append(" order by img_id desc ");
try
{
dst = this.m_dbo.Select(CConvert.ToString(sb));
}
catch (Exception e)
{
throw e;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(dst);
}
/// <summary>
///
/// </summary>
private void btnCancel_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要取消发票吗？", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
if (isSearch && dgvData.SelectedRows[0].Cells["payment_status"].Value != null)
{
int payment_status = CConvert.ToInt32(dgvData.SelectedRows[0].Cells["payment_status"].Value);
string slipnumber = CConvert.ToString(dgvData.SelectedRows[0].Cells["SLIP_NUMBER"].Value);
if (payment_status == 0 && !string.IsNullOrEmpty(slipnumber))
{
if (bPurchase.DeletePurchase(slipnumber))
{
MessageBox.Show("取消发票成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData(this.pgControl.GetCurrentPage());
}
else
{
MessageBox.Show("取消发票失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("该订单已付款或部分付款，不能取消发票。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception ex)
{
Logger.Error("取消发票：", ex);
}
}
}
/// <summary>
/// 绑定TreeView
/// </summary>
private void Bind_Tv(DataTable currentRoles)
{
DataTable dt = CCacheData.Function.Copy();
dt.Columns.Add("checked", Type.GetType("System.Boolean"));
//数据处理
foreach (DataRow dr in dt.Rows)
{
dr["checked"] = false;
foreach (DataRow row in currentRoles.Rows)
{
if (CConvert.ToString(dr["function_code"]) == CConvert.ToString(row["function_code"]))
{
dr["checked"] = true;
break;
}
}
}
//绑定
TreeNode pNode = null;
TreeNode cNode = null;
string pCode = "";
foreach (DataRow dr in dt.Rows)
{
if (pCode != CConvert.ToString(dr["code"]))
{
if (pCode == "")
{
pNode = new TreeNode();
}
else
{
pNode.ExpandAll();
tvFunction.Nodes.Add(pNode);
pNode = new TreeNode();
}
pCode = CConvert.ToString(dr["code"]);
pNode.Tag = pCode;
pNode.Text = CConvert.ToString(dr["name"]);
pNode.Checked = CConvert.ToBoolean(dr["checked"]);
}
cNode = new TreeNode();
cNode.Tag = CConvert.ToString(dr["function_code"]);
cNode.Text = CConvert.ToString(dr["title"]) + " " + CConvert.ToString(dr["memo"]);
cNode.Checked = CConvert.ToBoolean(dr["checked"]);
if (pNode.Checked)
{
pNode.Checked = CConvert.ToBoolean(dr["checked"]);
}
pNode.Nodes.Add(cNode);
}
if (pNode != null)
{
pNode.ExpandAll();
tvFunction.Nodes.Add(pNode);
}
}
/// <summary>
/// 权限更新
/// </summary>
public int UpdateRoles(DataTable rolesDt, string rolesCode)
{
List <CommandInfo> listSql = new List <CommandInfo>();
StringBuilder strSql = new StringBuilder();
strSql.Append(" delete from BASE_ROLES_FUNCTION ");
strSql.Append(" where ROLES_CODE = @ROLES_CODE ");
SqlParameter[] parames =
{
new SqlParameter("@ROLES_CODE", SqlDbType.VarChar)
};
parames[0].Value = rolesCode;
listSql.Add(new CommandInfo(strSql.ToString(), parames));
foreach (DataRow dr in rolesDt.Rows)
{
strSql = new StringBuilder();
strSql.Append(" insert into BASE_ROLES_FUNCTION ");
strSql.Append("(ROLES_CODE,FUNCTION_CODE)");
strSql.Append(" values ");
strSql.Append("(@ROLES_CODE,@FUNCTION_CODE)");
SqlParameter[] parameters =
{
new SqlParameter("@ROLES_CODE", SqlDbType.VarChar),
new SqlParameter("@FUNCTION_CODE", SqlDbType.VarChar)
};
parameters[0].Value = CConvert.ToString(dr["ROLES_CODE"]);
parameters[1].Value = CConvert.ToString(dr["FUNCTION_CODE"]);
listSql.Add(new CommandInfo(strSql.ToString(), parameters));
}
return(DbHelperSQL.ExecuteSqlTran(listSql));
}
/// <summary>
/// 引当数量的取得
/// </summary>
public decimal GetAlloationQuantity(string orderSlipNumber, string warehouseCode, string productCode)
{
decimal alloationQuantity = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT ISNULL(SUM(QUANTITY),0) FROM BLL_ALLOATION ");
strSql.Append(" where WAREHOUSE_CODE=@WAREHOUSE_CODE and PRODUCT_CODE = @PRODUCT_CODE and ORDER_SLIP_NUMBER<>@ORDER_SLIP_NUMBER");
strSql.AppendFormat(" and STATUS_FLAG <> {0} and STATUS_FLAG <> {1} ", CConstant.DELETE_STATUS, CConstant.ALLOATION_SHIPMENT);
SqlParameter[] parameters =
{
new SqlParameter("@WAREHOUSE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCT_CODE", SqlDbType.VarChar, 40),
new SqlParameter("@ORDER_SLIP_NUMBER", SqlDbType.VarChar, 20)
};
parameters[0].Value = warehouseCode;
parameters[1].Value = productCode;
parameters[2].Value = orderSlipNumber;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj != null)
{
alloationQuantity = CConvert.ToDecimal(obj);
}
return(alloationQuantity);
}
/// <summary>
/// loads the configuration from the config file
/// </summary>
public static void Load()
{
string strValue = ""; //value
//initialize
strValue = ConfigurationManager.AppSettings[C_KEY_CONNECTSTRING];
if (strValue != null)
{
m_strConnectString = strValue;
}
string strIsDebug = "";
strIsDebug = ConfigurationManager.AppSettings[C_KEY_DEBUG];
if (strIsDebug == C_TRUE)
{
m_bIsDebug = true;
}
else
{
m_bIsDebug = false;
}
//logÊä³ö·¾¶
m_sLogPath = ConfigurationManager.AppSettings["LogPath"];
m_sImagePath = ConfigurationManager.AppSettings["ImagePath"];
m_sSiteRoot = ConfigurationManager.AppSettings["SiteRoot"];
strValue = ConfigurationManager.AppSettings["DBTimeout"];
if (strValue != null)
{
m_nDBTimeout = CConvert.ToInt16(strValue);
}
}
private void InitPage()
{
try
{
string newsid = CConvert.ToString(Request["id"]);
DBB100 db = new DBB100();
if (FC_Check.IsNotEmpty(newsid))//修改
{
hidNewsId.Value = newsid;
DataSet dst = db.GetTrainInfoById(newsid);
if (dst != null && dst.Tables.Count > 0 && dst.Tables[0].Rows.Count > 0)
{
DataRow dr = dst.Tables[0].Rows[0];
string category = CConvert.ToString(dr["speed"]);
this.txtTitle.Text = CConvert.ToString(dr["title"]);
this.txtWordsCnt.Text = CConvert.ToString(dr["words"]);
newDesc.Value = CConvert.ToString(dr["content"]);
imgPhoto.ImageUrl = "../upload/test/" + CConvert.ToString(dr["photo"]);
ddlSpeadBind(category);
}
}
else
{
ddlSpeadBind("");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void FrmExchangeDialog_Load(object sender, EventArgs e)
{
if (_currentExchangeTable != null)
{
ExchangeDate.Value = _currentExchangeTable.EXCHANGE_DATE;
txtCurrencyCode.Text = _currentExchangeTable.FROM_CURRENCY_CODE;
if (!string.IsNullOrEmpty(_currentExchangeTable.FROM_CURRENCY_CODE) && bCommon.GetBaseMaster("CURRENCY", _currentExchangeTable.FROM_CURRENCY_CODE) != null)
{
txtCurrencyName.Text = bCommon.GetBaseMaster("CURRENCY", _currentExchangeTable.FROM_CURRENCY_CODE).Name;
}
txtExchangeRate.Text = CConvert.ToString(_currentExchangeTable.EXCHANGE_RATE);
}
if (_mode == CConstant.MODE_NEW)
{
this.Text = "新建";
}
else if (_mode == CConstant.MODE_MODIFY)
{
this.Text = "编辑";
txtCurrencyCode.BackColor = Color.WhiteSmoke;
ExchangeDate.BackColor = Color.WhiteSmoke;
txtCurrencyCode.Enabled = false;
ExchangeDate.Enabled = false;
btnCurrency.Enabled = false;
}
else if (_mode == CConstant.MODE_COPY)
{
this.Text = "新建";
txtCurrencyCode.Text = "";
ExchangeDate.Value = DateTime.Now;
txtCurrencyName.Text = "";
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
_currentDt = bStock.GetStockPrintList(oldGetCondition).Tables[0];
_currentDt.Columns.Add("ALLOATION_QUANTITY", Type.GetType("System.String"));
_currentDt.Columns.Add("NO_ALLOATION", Type.GetType("System.String"));
_currentDt.Columns.Add("RECEIPT_PLAN_QUANTITY", Type.GetType("System.String"));
foreach (DataRow rows in _currentDt.Rows)
{
decimal alloationQuantity = bAlloation.GetAlloationQuantity(CConvert.ToString(rows["WAREHOUSE_CODE"]), CConvert.ToString(rows["PRODUCT_CODE"]));
rows["ALLOATION_QUANTITY"] = Convert.ToString(alloationQuantity);
rows["NO_ALLOATION"] = Convert.ToDecimal(rows["QUANTITY"]) - Convert.ToDecimal(rows["ALLOATION_QUANTITY"]);
rows["RECEIPT_PLAN_QUANTITY"] = bStock.GetPurchaseQuantity(rows["WAREHOUSE_CODE"].ToString(), rows["PRODUCT_CODE"].ToString());
}
if (_currentDt.Rows.Count > 0 && isSearch)
{
int result = CommonExport.DataTableToExcel(_currentDt, CConstant.STOCK_HEADER, CConstant.STOCK_COLUMNS, "STOCK", "STOCK");
if (result == CConstant.EXPORT_SUCCESS)
{
MessageBox.Show("数据已经成功导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == CConstant.EXPORT_FAILURE)
{
MessageBox.Show("数据导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
/// 数据查询,绑定
/// </summary>
private void BindData(int currentPage)
{
string strWhere = GetConduction();
DataSet ds = bProductUnit.GetList(strWhere, "", (currentPage - 1) * PageSize + 1, currentPage * PageSize);
_currentDt = ds.Tables[0];
foreach (DataRow row in _currentDt.Rows)
{
try
{
if (row["CREATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])) != null)
{
row["CREATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])).Name;
}
if (row["LAST_UPDATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])) != null)
{
row["LAST_UPDATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])).Name;
}
}
catch { }
}
for (int i = _currentDt.Rows.Count; i < PageSize; i++)
{
_currentDt.Rows.Add(ds.Tables[0].NewRow());
}
this.dgvData.DataSource = _currentDt;
}
private void btnPrint_Click(object sender, EventArgs e)
{
_currentDt = bProductBuild.GetBuildSearchPrintList(GetConduction()).Tables[0];
_currentDt.Columns.Add("STATUS");
foreach (DataRow row in _currentDt.Rows)
{
if (CConvert.ToInt32(row["STATUS_FLAG"]) == CConstant.RELIEVE_STATUS)
{
row["STATUS"] = "解除";
}
}
_currentDt.Columns.Remove("STATUS_FLAG");
if (_currentDt.Rows.Count > 0 && isSearch)
{
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "HD_RELIEVE_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
string header = "组成编号\t仓库编号\t仓库名称\t组成品编号\t组成品名称\t解除数量\t组成时间\t公司编号\t公司名称\t组成品单位编号\t组成品单位名称\t创建人\t" +
"创建时间\t最后更新人\t最后更新时间\t材料明细编号\t材料编号\t材料名称\t材料解除数量\t材料单位编号\t材料单位名称\t状态\t\n";
if (sf.ShowDialog(this) == DialogResult.OK)
{
if (_currentDt != null)
{
int result = CExport.DataTableToCsv(_currentDt, header, sf.FileName);
if (result == 0)
{
MessageBox.Show("成功!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
}
private void FrmCompositionProductsProductionProcessDialog_Load(object sender, EventArgs e)
{
if (_currentCompositionProductsProductionProcessTable != null)
{
txtCompositionProductsCode.Text = _currentCompositionProductsProductionProcessTable.COMPOSITION_PRODUCTS_CODE;
txtCompositionProductsName.Text = _currentCompositionProductsProductionProcessTable.COMPOSITION_PRODUCTS_NAME;
txtProductionProcessCode.Text = _currentCompositionProductsProductionProcessTable.PRODUCTION_PROCESS_CODE;
txtProductionProcessName.Text = _currentCompositionProductsProductionProcessTable.PRODUCTION_PROCESS_NAME;
txtOrder.Text = CConvert.ToString(_currentCompositionProductsProductionProcessTable.ORDER);
}
if (_mode == CConstant.MODE_NEW)
{
this.Text = "新建";
}
else if (_mode == CConstant.MODE_MODIFY)
{
this.Text = "编辑";
txtCompositionProductsCode.BackColor = Color.WhiteSmoke;
txtProductionProcessCode.BackColor = Color.WhiteSmoke;
//txtCompositionProductsCode.Enabled = false;
//txtProductionProcessCode.Enabled = false;
//btnCompositionProducts.Enabled = false;
//btnProductionProcess.Enabled = false;
}
else if (_mode == CConstant.MODE_COPY)
{
this.Text = "新建";
txtCompositionProductsCode.BackColor = Color.WhiteSmoke;
txtCompositionProductsCode.Enabled = false;
btnCompositionProducts.Enabled = false;
txtProductionProcessCode.Text = "";
txtProductionProcessName.Text = "";
txtOrder.Text = "";
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (isSearch && dgvData.SelectedRows.Count > 0)
{
DataGridViewRow dgvr = dgvData.SelectedRows[0];
string slipNumber = CConvert.ToString(dgvr.Cells["SLIP_NUMBER"].Value);
if (MessageBox.Show("确定要出库取消吗？", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
//
if (CConvert.ToInt32(dgvr.Cells["STATUS_FLAG"].Value) == CConstant.NORMAL)
{
MessageBox.Show("销售发票已开，不能进行出库取消。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
string orderSlipNumber = CConvert.ToString(dgvr.Cells["ORDER_SLIP_NUMBER"].Value);
int ret = bShipment.DeleteShipment(slipNumber, UserTable.CODE);
if (ret > 0)
{
MessageBox.Show("出库取消成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData(pgControl.GetCurrentPage());
bCommon.ReSetAlloation(orderSlipNumber);
}
}
catch (Exception ex)
{
MessageBox.Show("出库取消失败，请重试或与系统管理员联系。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Logger.Error("出库取消失败", ex);
}
}
}
}
/// <summary>
/// 分配解除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvData.SelectedRows.Count > 0)
{
if (DialogResult.OK == MessageBox.Show("确定要解除吗？", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
string slipNumber = CConvert.ToString(dgvData.SelectedRows[0].Cells["SLIP_NUMBER"].Value);
string lineNumber = CConvert.ToString(dgvData.SelectedRows[0].Cells["LINE_NUMBER"].Value);
try
{
if (bDepositArr.Delete(slipNumber, lineNumber))
{
MessageBox.Show("分配解除成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData(pgControl.GetCurrentPage());
}
else
{
MessageBox.Show("分配解除失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("分配解除失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Logger.Error("分配解除失败。", ex);
}
}
}
else
{
MessageBox.Show("请先选择一行。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void initOperate(int currentPage)
{
BllShipmentTable shipment = bShipment.GetModel(slipnumber);
BllOrderHeaderTable orderheader = bOrderHeader.GetModel(shipment.ORDER_SLIP_NUMBER);
txtSlipNumber.Text = slipnumber;
txtOrderSlipNumber.Text = shipment.ORDER_SLIP_NUMBER;
//txtCustomerCode.Text = orderheader.CUSTOMER_CODE;
//txtCustomerName.Text = orderheader.CUSTOMER_NAME;
txtEndCustomerCode.Text = orderheader.ENDER_CUSTOMER_CODE;
txtEndCustomerName.Text = orderheader.ENDER_CUSTOMER_NAME;
//txtDeliveryPointCode.Text = orderheader.ENDER_CUSTOMER_CODE;
//txtDeliveryPointName.Text = orderheader.ENDER_CUSTOMER_NAME;
//txtSerialNumber.Text = shipment.SERIAL_NUMBER;
txtCustomerPoNumber.Text = orderheader.CUSTOMER_PO_NUMBER;
txtOrderSlipDateFrom.Value = CConvert.ToDateTime(orderheader.SLIP_DATE.ToString());
txtOrderSlipDateTo.Value = CConvert.ToDateTime(orderheader.SLIP_DATE.ToString());
txtSlipDateFrom.Value = CConvert.ToDateTime(shipment.SLIP_DATE.ToString("yyyy-MM-dd"));
txtSlipDateTo.Value = CConvert.ToDateTime(shipment.SLIP_DATE.ToString("yyyy-MM-dd"));
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" STATUS_FLAG <> {0}", CConstant.DELETE);
sb.AppendFormat(" AND SLIP_NUMBER = '{0}'", slipnumber);
DataSet ds = bShipment.GetList(sb.ToString(), "", (currentPage - 1) * PageSize + 1, currentPage * PageSize);
int recordCount = bShipment.GetRecordCount(sb.ToString());
_currentDt = ds.Tables[0];
reSetCurrentDt();
this.dgvData.DataSource = _currentDt;
this.pgControl.init(GetTotalPage(recordCount), currentPage);
}
/// <summary>
/// 导出
/// </summary>
private void MasterToolBar_DoExport_Click(object sender, EventArgs e)
{
_currentDt = bProduct.GetList(GetConduction()).Tables[0];
if (isSearch && _currentDt != null)
{
foreach (DataRow row in _currentDt.Rows)
{
try
{
if (row["CREATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])) != null)
{
row["CREATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["CREATE_USER"])).Name;
}
if (row["LAST_UPDATE_USER"] != null && bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])) != null)
{
row["LAST_UPDATE_USER"] = bCommon.GetBaseMaster("USER", CConvert.ToString(row["LAST_UPDATE_USER"])).Name;
}
}
catch { }
}
int result = CommonExport.DataTableToExcel(_currentDt, CConstant.PRODUCT_HEADER, CConstant.PRODUCT_COLUMNS, "PRODUCT", "PRODUCT");
if (result == CConstant.EXPORT_SUCCESS)
{
MessageBox.Show("数据已经成功导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (result == CConstant.EXPORT_FAILURE)
{
MessageBox.Show("数据导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("没有可以导出的数据。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 获取滚动图片信息
/// </summary>
/// <param name="sType">类型</param>
/// <returns></returns>
public int CreateVerCode(int iNum)
{
int iRet = 0;
StringBuilder sb = new StringBuilder();
m_dbo.RemoveAllParameters();
sb.Append(" insert into td_license ");
sb.Append(" (code,state) ");
sb.Append(" values ");
sb.Append(" (?code,1) ");
try
{
for (int i = 0; i < iNum; i++)
{
m_dbo.RemoveAllParameters();
m_dbo.AddParameter("code", Guid.NewGuid().ToString().Replace("-", ""));
iRet += this.m_dbo.ExecuteSQL(CConvert.ToString(sb));
}
}
catch (Exception e)
{
iRet = -1;
}
finally
{
try
{
this.m_dbo.Close();
}
catch { }
}
return(iRet);
}
