private void txtDepartualCode_Leave(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(this.txtDepartualCode.Text.Trim()))
{
BaseWarehouseTable Warehouse = new BaseWarehouseTable();
BWarehouse bWarehouse = new BWarehouse();
Warehouse = bWarehouse.GetModel(this.txtDepartualCode.Text);
if (Warehouse == null || "".Equals(Warehouse))
{
txtDepartualCode.Focus();
txtDepartualCode.Text = "";
txtDepartualName.Text = "";
MessageBox.Show("仓库编号不存在，请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
txtDepartualCode.Text = Warehouse.CODE;
txtDepartualName.Text = Warehouse.NAME;
}
}
else
{
txtDepartualName.Text = "";
}
}
private void txtWarehouseCode_Leave(object sender, EventArgs e)
{
//判断编号是否已存在
if (!string.IsNullOrEmpty(this.txtWarehouseCode.Text.Trim()) && !string.IsNullOrEmpty(this.txtProductCode.Text.Trim()))
{
BaseSafetyStockTable SafetyCode = new BaseSafetyStockTable();
SafetyCode = bSafetyStock.GetModel(txtWarehouseCode.Text, txtProductCode.Text);
if (SafetyCode != null)
{
txtWarehouseCode.Text = "";
txtWarehouseName.Text = "";
txtProductCode.Text = "";
txtProductName.Text = "";
txtWarehouseCode.Focus();
MessageBox.Show("仓库编号与商品编号的组合已存在，请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
if (!string.IsNullOrEmpty(this.txtWarehouseCode.Text.Trim()))
{
BaseWarehouseTable Warehouse = new BaseWarehouseTable();
BWarehouse bWarehouse = new BWarehouse();
Warehouse = bWarehouse.GetModel(this.txtWarehouseCode.Text);
if (Warehouse == null || "".Equals(Warehouse))
{
txtWarehouseCode.Focus();
txtWarehouseCode.Text = "";
txtWarehouseName.Text = "";
MessageBox.Show("仓库编号不存在，请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
txtWarehouseName.Text = Warehouse.NAME;
}
}
}
/// <summary>
/// 当前明细己引当的仓库的取得
/// </summary>
public BaseWarehouseTable GetAlloationWarehouse(string orderSlipNumber, int orderLineNumber)
{
BaseWarehouseTable warehouseTable = new BaseWarehouseTable();
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT BA.WAREHOUSE_CODE,BW.NAME FROM BLL_ALLOATION AS BA");
strSql.Append(" LEFT JOIN BASE_WAREHOUSE AS BW ON BW.CODE = BA.WAREHOUSE_CODE ");
strSql.Append(" where BA.ORDER_SLIP_NUMBER=@ORDER_SLIP_NUMBER and BA.ORDER_LINE_NUMBER = @ORDER_LINE_NUMBER ");
strSql.AppendFormat(" and BA.STATUS_FLAG <> {0} and BA.STATUS_FLAG <> {1} ", CConstant.DELETE, CConstant.ALLOATION_SHIPMENT);
SqlParameter[] parameters =
{
new SqlParameter("@ORDER_SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@ORDER_LINE_NUMBER", SqlDbType.Int, 4)
};
parameters[0].Value = orderSlipNumber;
parameters[1].Value = orderLineNumber;
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
warehouseTable.CODE = dr["WAREHOUSE_CODE"].ToString();
warehouseTable.NAME = dr["NAME"].ToString();
}
}
return(warehouseTable);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BaseWarehouseTable GetModel(string CODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CODE,NAME,NAME_SHORT,ZIP_CODE,ADDRESS_FIRST,ADDRESS_MIDDLE,ADDRESS_LAST,PHONE_NUMBER,FAX_NUMBER,MOBIL_NUMBER,CONTACT_NAME,EMAIL,MEMO,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_USER,LAST_UPDATE_TIME from BASE_WAREHOUSE ");
strSql.Append(" where CODE=@CODE ");
strSql.AppendFormat(" and STATUS_FLAG <> {0}", CConstant.DELETE_STATUS);
SqlParameter[] parameters =
{
new SqlParameter("@CODE", SqlDbType.VarChar, 50)
};
parameters[0].Value = CODE;
BaseWarehouseTable model = new BaseWarehouseTable();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.CODE = ds.Tables[0].Rows[0]["CODE"].ToString();
model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString();
model.NAME_SHORT = ds.Tables[0].Rows[0]["NAME_SHORT"].ToString();
model.ZIP_CODE = ds.Tables[0].Rows[0]["ZIP_CODE"].ToString();
model.ADDRESS_FIRST = ds.Tables[0].Rows[0]["ADDRESS_FIRST"].ToString();
model.ADDRESS_MIDDLE = ds.Tables[0].Rows[0]["ADDRESS_MIDDLE"].ToString();
model.ADDRESS_LAST = ds.Tables[0].Rows[0]["ADDRESS_LAST"].ToString();
model.PHONE_NUMBER = ds.Tables[0].Rows[0]["PHONE_NUMBER"].ToString();
model.FAX_NUMBER = ds.Tables[0].Rows[0]["FAX_NUMBER"].ToString();
model.MOBIL_NUMBER = ds.Tables[0].Rows[0]["MOBIL_NUMBER"].ToString();
model.CONTACT_NAME = ds.Tables[0].Rows[0]["CONTACT_NAME"].ToString();
model.EMAIL = ds.Tables[0].Rows[0]["EMAIL"].ToString();
model.MEMO = ds.Tables[0].Rows[0]["MEMO"].ToString();
if (ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString() != "")
{
model.STATUS_FLAG = int.Parse(ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString());
}
model.CREATE_USER = ds.Tables[0].Rows[0]["CREATE_USER"].ToString();
if (ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString() != "")
{
model.CREATE_DATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString());
}
model.LAST_UPDATE_USER = ds.Tables[0].Rows[0]["LAST_UPDATE_USER"].ToString();
if (ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString() != "")
{
model.LAST_UPDATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString());
}
return(model);
}
else
{
return(null);
}
}
private void txtCode_Leave(object sender, EventArgs e)
{
//判断编号是否已存在
if (!string.IsNullOrEmpty(this.txtCode.Text.Trim()))
{
BaseWarehouseTable WarehouseCode = new BaseWarehouseTable();
WarehouseCode = bWarehouse.GetModel(txtCode.Text);
if (WarehouseCode != null)
{
txtCode.Focus();
txtCode.Text = "";
MessageBox.Show("编号已存在，请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
/// <summary>
/// 保存
/// </summary>
private void btnSave_Click_1(object sender, EventArgs e)
{
if (CheckInput())
{
if (_currentWarehouseTable == null)
{
_currentWarehouseTable = new BaseWarehouseTable();
}
_currentWarehouseTable.CODE = txtCode.Text.Trim();
_currentWarehouseTable.NAME = txtName.Text.Trim();
_currentWarehouseTable.NAME_SHORT = txtNameShort.Text.Trim();
_currentWarehouseTable.ZIP_CODE = txtZipCode.Text.Trim();
_currentWarehouseTable.ADDRESS_FIRST = txtAddressFirst.Text.Trim();
_currentWarehouseTable.ADDRESS_MIDDLE = txtAddressMiddle.Text.Trim();
_currentWarehouseTable.ADDRESS_LAST = txtAddressLast.Text.Trim();
_currentWarehouseTable.PHONE_NUMBER = txtPhone.Text.Trim();
_currentWarehouseTable.FAX_NUMBER = txtFax.Text.Trim();
_currentWarehouseTable.MOBIL_NUMBER = txtMobil.Text.Trim();
_currentWarehouseTable.CONTACT_NAME = txtContactName.Text.Trim();
_currentWarehouseTable.EMAIL = txtEmail.Text.Trim();
_currentWarehouseTable.MEMO = txtMemo.Text.Trim();
_currentWarehouseTable.LAST_UPDATE_USER = _userInfo.CODE;
try
{
if (bWarehouse.Exists(txtCode.Text.Trim()))
{
bWarehouse.Update(_currentWarehouseTable);
}
else
{
_currentWarehouseTable.CREATE_USER = _userInfo.CODE;
bWarehouse.Add(_currentWarehouseTable);
}
}
catch (Exception ex)
{
//log.error
MessageBox.Show("");
return;
}
result = DialogResult.OK;
this.Close();
CCacheData.WAREHOUSE = null;
}
}
/// <summary>
/// 获得当前选中的数据
/// </summary>
private void GetCurrentSelectedTable()
{
try
{
string code = dgvData.SelectedRows[0].Cells[0].Value.ToString();
if (code != "")
{
_currentWarehouseTable = bWarehouse.GetModel(code);
}
}
catch (Exception ex) { }
if (_currentWarehouseTable == null || _currentWarehouseTable.CODE == null || "".Equals(_currentWarehouseTable.CODE))
{
_currentWarehouseTable = null;
}
}
/// <summary>
/// 打开新窗口
/// </summary>
private void OpenDialogFrm(int mode)
{
if (mode == CConstant.MODE_NEW || _currentWarehouseTable != null)
{
FrmWarehouseDialog frm = new FrmWarehouseDialog();
frm.UserInfo = _userInfo;
frm.CurrentWarehouseTable = _currentWarehouseTable;
frm.Mode = mode;
DialogResult resule = frm.ShowDialog(this);
if (resule == DialogResult.OK && isSearch)
{
Search(this.pgControl.GetCurrentPage());
}
frm.Dispose();
}
else
{
//MessageBox.Show("请选择正确的行!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
_currentWarehouseTable = null;
}
/// <summary>
/// 删除
/// </summary>
private void MasterToolBar_DoDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确定要删除吗？", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
try
{
GetCurrentSelectedTable();
if (_currentWarehouseTable != null)
{
bWarehouse.Delete(_currentWarehouseTable.CODE);
Search(this.pgControl.GetCurrentPage());
}
else
{
MessageBox.Show("请选择正确的行!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show("删除失败，请重试或与系统管理员联系。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
_currentWarehouseTable = null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BaseWarehouseTable model)
{
StringBuilder strSql = null;
int rows = 0;
if (Exists(model.CODE))
{
#region 更新
strSql = new StringBuilder();
strSql.Append("update BASE_WAREHOUSE set ");
strSql.Append("NAME=@NAME,");
strSql.Append("NAME_SHORT=@NAME_SHORT,");
strSql.Append("ZIP_CODE=@ZIP_CODE,");
strSql.Append("ADDRESS_FIRST=@ADDRESS_FIRST,");
strSql.Append("ADDRESS_MIDDLE=@ADDRESS_MIDDLE,");
strSql.Append("ADDRESS_LAST=@ADDRESS_LAST,");
strSql.Append("PHONE_NUMBER=@PHONE_NUMBER,");
strSql.Append("FAX_NUMBER=@FAX_NUMBER,");
strSql.Append("MOBIL_NUMBER=@MOBIL_NUMBER,");
strSql.Append("CONTACT_NAME=@CONTACT_NAME,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("MEMO=@MEMO,");
strSql.Append("STATUS_FLAG=@STATUS_FLAG,");
strSql.Append("CREATE_USER=@CREATE_USER,");
strSql.Append("CREATE_DATE_TIME=@GETDATE(),");
strSql.Append("LAST_UPDATE_USER=@LAST_UPDATE_USER,");
strSql.Append("LAST_UPDATE_TIME=GETDATE()");
strSql.Append(" where CODE=@CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@CODE", SqlDbType.VarChar, 20),
new SqlParameter("@NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@NAME_SHORT", SqlDbType.NVarChar, 50),
new SqlParameter("@ZIP_CODE", SqlDbType.VarChar, 8),
new SqlParameter("@ADDRESS_FIRST", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_MIDDLE", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_LAST", SqlDbType.NVarChar, 100),
new SqlParameter("@PHONE_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@FAX_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@MOBIL_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@CONTACT_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@EMAIL", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.NVarChar, 255),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.CODE;
parameters[1].Value = model.NAME;
parameters[2].Value = model.NAME_SHORT;
parameters[3].Value = model.ZIP_CODE;
parameters[4].Value = model.ADDRESS_FIRST;
parameters[5].Value = model.ADDRESS_MIDDLE;
parameters[6].Value = model.ADDRESS_LAST;
parameters[7].Value = model.PHONE_NUMBER;
parameters[8].Value = model.FAX_NUMBER;
parameters[9].Value = model.MOBIL_NUMBER;
parameters[10].Value = model.CONTACT_NAME;
parameters[11].Value = model.EMAIL;
parameters[12].Value = model.MEMO;
parameters[13].Value = CConstant.NORMAL_STATUS;
parameters[14].Value = model.CREATE_USER;
parameters[15].Value = model.LAST_UPDATE_USER;
rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
#endregion
}
else
{
#region 增加
strSql = new StringBuilder();
strSql.Append("insert into BASE_WAREHOUSE(");
strSql.Append("CODE,NAME,NAME_SHORT,ZIP_CODE,ADDRESS_FIRST,ADDRESS_MIDDLE,ADDRESS_LAST,PHONE_NUMBER,FAX_NUMBER,MOBIL_NUMBER,CONTACT_NAME,EMAIL,MEMO,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_USER,LAST_UPDATE_TIME)");
strSql.Append(" values (");
strSql.Append("@CODE,@NAME,@NAME_SHORT,@ZIP_CODE,@ADDRESS_FIRST,@ADDRESS_MIDDLE,@ADDRESS_LAST,@PHONE_NUMBER,@FAX_NUMBER,@MOBIL_NUMBER,@CONTACT_NAME,@EMAIL,@MEMO,@STATUS_FLAG,@CREATE_USER,GETDATE(),@LAST_UPDATE_USER,GETDATE())");
SqlParameter[] parameters =
{
new SqlParameter("@CODE", SqlDbType.VarChar, 20),
new SqlParameter("@NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@NAME_SHORT", SqlDbType.NVarChar, 50),
new SqlParameter("@ZIP_CODE", SqlDbType.VarChar, 8),
new SqlParameter("@ADDRESS_FIRST", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_MIDDLE", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_LAST", SqlDbType.NVarChar, 100),
new SqlParameter("@PHONE_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@FAX_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@MOBIL_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@CONTACT_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@EMAIL", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.NVarChar, 255),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.CODE;
parameters[1].Value = model.NAME;
parameters[2].Value = model.NAME_SHORT;
parameters[3].Value = model.ZIP_CODE;
parameters[4].Value = model.ADDRESS_FIRST;
parameters[5].Value = model.ADDRESS_MIDDLE;
parameters[6].Value = model.ADDRESS_LAST;
parameters[7].Value = model.PHONE_NUMBER;
parameters[8].Value = model.FAX_NUMBER;
parameters[9].Value = model.MOBIL_NUMBER;
parameters[10].Value = model.CONTACT_NAME;
parameters[11].Value = model.EMAIL;
parameters[12].Value = model.MEMO;
parameters[13].Value = CConstant.NORMAL_STATUS;
parameters[14].Value = model.CREATE_USER;
parameters[15].Value = model.LAST_UPDATE_USER;
rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
#endregion
}
if (rows > 0)
{
CCacheData.WAREHOUSE = null;
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BaseWarehouseTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_WAREHOUSE set ");
strSql.Append("NAME=@NAME,");
strSql.Append("NAME_SHORT=@NAME_SHORT,");
strSql.Append("ZIP_CODE=@ZIP_CODE,");
strSql.Append("ADDRESS_FIRST=@ADDRESS_FIRST,");
strSql.Append("ADDRESS_MIDDLE=@ADDRESS_MIDDLE,");
strSql.Append("ADDRESS_LAST=@ADDRESS_LAST,");
strSql.Append("PHONE_NUMBER=@PHONE_NUMBER,");
strSql.Append("FAX_NUMBER=@FAX_NUMBER,");
strSql.Append("MOBIL_NUMBER=@MOBIL_NUMBER,");
strSql.Append("CONTACT_NAME=@CONTACT_NAME,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("MEMO=@MEMO,");
strSql.Append("STATUS_FLAG=@STATUS_FLAG,");
strSql.Append("LAST_UPDATE_USER=@LAST_UPDATE_USER,");
strSql.Append("LAST_UPDATE_TIME=GETDATE()");
strSql.Append(" where CODE=@CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@CODE", SqlDbType.VarChar, 20),
new SqlParameter("@NAME", SqlDbType.NVarChar, 100),
new SqlParameter("@NAME_SHORT", SqlDbType.NVarChar, 50),
new SqlParameter("@ZIP_CODE", SqlDbType.VarChar, 8),
new SqlParameter("@ADDRESS_FIRST", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_MIDDLE", SqlDbType.NVarChar, 100),
new SqlParameter("@ADDRESS_LAST", SqlDbType.NVarChar, 100),
new SqlParameter("@PHONE_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@FAX_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@MOBIL_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@CONTACT_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@EMAIL", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.NVarChar, 255),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.CODE;
parameters[1].Value = model.NAME;
parameters[2].Value = model.NAME_SHORT;
parameters[3].Value = model.ZIP_CODE;
parameters[4].Value = model.ADDRESS_FIRST;
parameters[5].Value = model.ADDRESS_MIDDLE;
parameters[6].Value = model.ADDRESS_LAST;
parameters[7].Value = model.PHONE_NUMBER;
parameters[8].Value = model.FAX_NUMBER;
parameters[9].Value = model.MOBIL_NUMBER;
parameters[10].Value = model.CONTACT_NAME;
parameters[11].Value = model.EMAIL;
parameters[12].Value = model.MEMO;
parameters[13].Value = model.STATUS_FLAG;
parameters[14].Value = model.LAST_UPDATE_USER;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
CCacheData.WAREHOUSE = null;
return(true);
}
else
{
return(false);
}
}
public override string[] doUpdateDB()
{
BaseWarehouseTable WarehouseTable = null;
BWarehouse bWarehouse = new BWarehouse();
StringBuilder strError = new StringBuilder();
int successData = 0;
int failureData = 0;
string errorFilePath = "";
string backupFilePath = "";
//数据导入处理
foreach (DataRow dr in _csvDataTable.Rows)
{
StringBuilder str = new StringBuilder();
//编号
if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "CODE"))))
{
str.Append(CheckString(GetValue(dr, "CODE"), 20, "编号"));
}
else
{
str.Append("编号不能为空!");
}
//名称
str.Append(CheckLenght(GetValue(dr, "NAME"), 100, "名称"));
//简称
str.Append(CheckLenght(GetValue(dr, "NAME_SHORT"), 50, "简称"));
//邮编
str.Append(CheckLenght(GetValue(dr, "ZIP_CODE"), 8, "邮编"));
//地址1
str.Append(CheckLenght(GetValue(dr, "ADDRESS_FIRST"), 100, "地址1"));
//地址2
str.Append(CheckLenght(GetValue(dr, "ADDRESS_MIDDLE"), 100, "地址2"));
//地址3
str.Append(CheckLenght(GetValue(dr, "ADDRESS_LAST"), 100, "地址3"));
//电话
str.Append(CheckLenght(GetValue(dr, "PHONE_NUMBER"), 20, "电话"));
//传真
str.Append(CheckLenght(GetValue(dr, "FAX_NUMBER"), 20, "传真"));
//联系人名称
str.Append(CheckLenght(GetValue(dr, "CONTACT_NAME"), 50, "联系人名称"));
//联系人电话
str.Append(CheckLenght(GetValue(dr, "MOBIL_NUMBER"), 20, "联系人电话"));
//邮箱
str.Append(CheckLenght(GetValue(dr, "EMIAL"), 50, "邮箱"));
//备注
str.Append(CheckLenght(GetValue(dr, "MEMO"), 255, "备注"));
//状态
str.Append(CheckInt(GetValue(dr, "STATUS_FLAG", 1), 9, "状态"));
if (str.ToString().Trim().Length > 0)
{
strError.Append(GetStringBuilder(dr, str.ToString().Trim()));
failureData++;
continue;
}
try
{
WarehouseTable = new BaseWarehouseTable();
WarehouseTable.CODE = CConvert.ToString(GetValue(dr, "CODE"));
WarehouseTable.NAME = CConvert.ToString(GetValue(dr, "NAME"));
WarehouseTable.NAME_SHORT = CConvert.ToString(GetValue(dr, "NAME_SHORT"));
WarehouseTable.ZIP_CODE = CConvert.ToString(GetValue(dr, "ZIP_CODE"));
WarehouseTable.ADDRESS_FIRST = CConvert.ToString(GetValue(dr, "ADDRESS_FIRST"));
WarehouseTable.ADDRESS_MIDDLE = CConvert.ToString(GetValue(dr, "ADDRESS_MIDDLE"));
WarehouseTable.ADDRESS_LAST = CConvert.ToString(GetValue(dr, "ADDRESS_LAST"));
WarehouseTable.PHONE_NUMBER = CConvert.ToString(GetValue(dr, "PHONE_NUMBER"));
WarehouseTable.FAX_NUMBER = CConvert.ToString(GetValue(dr, "FAX_NUMBER"));
WarehouseTable.CONTACT_NAME = CConvert.ToString(GetValue(dr, "CONTACT_NAME"));
WarehouseTable.MOBIL_NUMBER = CConvert.ToString(GetValue(dr, "MOBIL_NUMBER"));
WarehouseTable.EMAIL = CConvert.ToString(GetValue(dr, "EMIAL"));
WarehouseTable.MEMO = CConvert.ToString(GetValue(dr, "MEMO"));
WarehouseTable.STATUS_FLAG = CConvert.ToInt32(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS));
WarehouseTable.CREATE_USER = _userInfo.CODE;
WarehouseTable.LAST_UPDATE_USER = _userInfo.CODE;
if (!bWarehouse.Exists(WarehouseTable.CODE))
{
WarehouseTable.CREATE_DATE_TIME = DateTime.Now;
WarehouseTable.LAST_UPDATE_TIME = DateTime.Now;
bWarehouse.Add(WarehouseTable);
}
else
{
WarehouseTable.LAST_UPDATE_TIME = DateTime.Now;
bWarehouse.Update(WarehouseTable);
}
successData++;
}
catch
{
strError.Append(GetStringBuilder(dr, " 数据导入失败，请与系统管理员联系！").ToString());
failureData++;
}
}
//错误记录处理
if (strError.Length > 0)
{
errorFilePath = WriteFile(strError.ToString());
}
//备份处理
backupFilePath = BackupFile();
return(new string[] { successData.ToString(), failureData.ToString(), errorFilePath, backupFilePath });
}
private void FrmAlloation_Load(object sender, EventArgs e)
{
BllOrderHeaderTable headerTable = bOrderHeader.GetModel(_slipNumber);
this.txtSlipNumber.Text = headerTable.SLIP_NUMBER;
this.txtCustomerCode.Text = headerTable.CUSTOMER_CODE;
this.txtCustomerName.Text = headerTable.CUSTOMER_NAME;
this.txtEndCustomerCode.Text = headerTable.ENDER_CUSTOMER_CODE;
this.txtEndCustomerName.Text = headerTable.ENDER_CUSTOMER_NAME;
this.txtDeliveryPointCode.Text = headerTable.DELIVERY_POINT_CODE;
this.txtDeliveryPointName.Text = headerTable.DELIVERY_POINT_NAME;
this.txtOwnerPoNumber.Text = headerTable.CUSTOMER_PO_NUMBER;
this.txtSlipDate.Text = CConvert.DateTimeToString(headerTable.SLIP_DATE, "yyyy-MM-dd");
this.txtDepartualDate.Text = CConvert.DateTimeToString(headerTable.DEPARTUAL_DATE, "yyyy-MM-dd");
DataGridViewComboBoxColumn co = this.dgvData.Columns["DEPARTUAL_WAREHOUSE"] as DataGridViewComboBoxColumn;
co.DataSource = CCacheData.WAREHOUSE.Copy();
co.DisplayMember = "NAME";
co.ValueMember = "CODE";
foreach (BllOrderLineTable lineModel in headerTable.Items)
{
decimal quantity = CConvert.ToDecimal(lineModel.QUANTITY) - CConvert.ToDecimal(lineModel.SHIPMENT_QUANTITY);
int currentRowIndex = dgvData.Rows.Add(1);
DataGridViewRow dgvr = dgvData.Rows[currentRowIndex];
dgvr.Cells["NO"].Value = lineModel.LINE_NUMBER;
dgvr.Cells["PRODUCT_CODE"].Value = lineModel.PRODUCT_CODE;
dgvr.Cells["PRODUCT_NAME"].Value = lineModel.PRODUCT_NAME;
dgvr.Cells["PRODUCT_SPEC"].Value = lineModel.PRODUCT_SPEC;
dgvr.Cells["QUANTITY"].Value = quantity;
dgvr.Cells["UNIT_CODE"].Value = lineModel.UNIT_NAME;
dgvr.Cells["UNIT_NAME"].Value = lineModel.UNIT_NAME;
dgvr.Cells["REF_STOCK"].Value = "参照";
//当前己引当的仓库的取得
BaseWarehouseTable warehouseTable = bAlloation.GetAlloationWarehouse(headerTable.SLIP_NUMBER, lineModel.LINE_NUMBER);
string warehouseCode = warehouseTable.CODE;
if (warehouseCode != null && warehouseCode != "")
{
((DataGridViewComboBoxCell)dgvr.Cells["DEPARTUAL_WAREHOUSE"]).Style.NullValue = warehouseTable.NAME + " ";
}
else
{
warehouseCode = headerTable.DEPARTUAL_WAREHOUSE_CODE;
((DataGridViewComboBoxCell)dgvr.Cells["DEPARTUAL_WAREHOUSE"]).Style.NullValue = headerTable.DEPARTUAL_WAREHOUSE_NAME + " ";
}
dgvr.Cells["DEFAULT_WAREHOUSE_CODE"].Value = warehouseCode;
//当前仓库实际库存的取得
BaseStockTable stockTable = bStock.GetModel(warehouseCode, lineModel.PRODUCT_CODE);
decimal stock = 0;
if (stockTable != null)
{
stock = CConvert.ToDecimal(stockTable.QUANTITY);
}
//己使用的引当数量,当前订单除外,己出库数量除外
stock -= bAlloation.GetAlloationQuantity(headerTable.SLIP_NUMBER, warehouseCode, lineModel.PRODUCT_CODE);
dgvr.Cells["STOCK"].Value = stock;
dgvr.Cells["ALLOATION_QUANTITY"].Value = quantity;
BaseProductTable pTable = null;
if (lineModel.PRODUCT_CODE.Length >= 4 && lineModel.PRODUCT_CODE.Substring(0, 4) == "9999")
{
pTable = bProduct.GetModel(lineModel.PRODUCT_CODE.Substring(0, 4));
}
else
{
pTable = bProduct.GetModel(lineModel.PRODUCT_CODE);
}
if (pTable.STOCK_FLAG == 2)
{
dgvr.Cells["IS_ALLOATION"].Value = "OK";
}
else if (quantity > stock)
{
dgvr.Cells["IS_ALLOATION"].Value = "NG";
}
else
{
dgvr.Cells["IS_ALLOATION"].Value = "OK";
}
}
}
private void btnPurcahse_Click(object sender, EventArgs e)
{
if (dgvData.SelectedRows.Count > 0)
{
Hashtable ht = null;
DataTable dt = null;
DataGridViewRow row = dgvData.SelectedRows[0];
BaseCompanyTable company = new BCompany().GetModel(_userInfo.COMPANY_CODE);
BllPurchaseOrderTable purchase = bPurchaseOrder.GetModel(CConvert.ToString(row.Cells["SLIP_NUMBER"].Value));
BllOrderHeaderTable order = new BOrderHeader().GetModel(purchase.ORDER_SLIP_NUMBER);
BaseWarehouseTable warehouse = new BWarehouse().GetModel(purchase.RECEIPT_WAREHOUSE_CODE);
if (company == null)
{
company = new BaseCompanyTable();
}
if (warehouse == null)
{
warehouse = new BaseWarehouseTable();
}
if (purchase == null)
{
purchase = new BllPurchaseOrderTable();
}
BaseSupplierTable supplier = new BSupplier().GetModel(purchase.SUPPLIER_CODE);
if (supplier.TYPE == 2)
{
#region 国内
ht = new Hashtable();
ht.Add("&COMPANY_NAME", company.NAME);
ht.Add("&ADDRESS", company.ADDRESS_FIRST + company.ADDRESS_MIDDLE + company.ADDRESS_LAST);
if (string.IsNullOrEmpty(company.PHONE_NUMBER.ToString()))
{
ht.Add("&PHONE", "TEL " + "FAX" + company.FAX_NUMBER);
}
else
{
ht.Add("&PHONE", "TEL" + company.PHONE_NUMBER.ToString() + "FAX" + company.FAX_NUMBER);
}
ht.Add("&SLIP_NUMBER", purchase.SLIP_NUMBER);
ht.Add("&SLIP_DATE", purchase.SLIP_DATE.ToString("yyyy年MM月dd日"));
ht.Add("&SUPPLIER", "厂商名称:" + supplier.NAME);
//
ht.Add("&NAME", company.NAME);
ht.Add("&DUE_DATE", "1.交货日期：" + CConvert.ToDateTime(purchase.DUE_DATE).ToShortDateString());
ht.Add("&PACKING_METHOD", "2.包装方式：" + purchase.PACKING_METHOD);
ht.Add("&WAREHOUSE_NAME", "3.交货地址：" + warehouse.ADDRESS_FIRST + warehouse.ADDRESS_MIDDLE + warehouse.ADDRESS_LAST);
ht.Add("&PAYMENT_CONDITION", "4.支付方式：" + purchase.PAYMENT_CONDITION);
dt = new DataTable();
dt.Columns.Add("NO");
dt.Columns.Add("MODEL_NUMBER");
dt.Columns.Add("PRODUCT_NAME");
dt.Columns.Add("SPEC");
dt.Columns.Add("QUANTITY");
dt.Columns.Add("PRICE");
dt.Columns.Add("AMOUNT_WITHOUT_TAX");
//dt.Columns.Add("AMOUNT_INCLUDED_TAX");
dt.Columns.Add("DUE_DATE");
decimal amount = 0;
decimal taxAmount = 0;
DataRow rows = null;
foreach (BllPurchaseOrderLineTable OLModel in purchase.Items)
{
rows = dt.NewRow();
rows["NO"] = OLModel.LINE_NUMBER;
if (OLModel.PRODUCT_CODE.Length >= 4 && OLModel.PRODUCT_CODE.Substring(0, 4) == "9999")
{
rows["PRODUCT_NAME"] = OLModel.PRODUCT_NAME;
rows["SPEC"] = OLModel.PRODUCT_SPEC;
rows["MODEL_NUMBER"] = "";
}
else
{
BaseProductTable product = new BProduct().GetModel(OLModel.PRODUCT_CODE);
if (product != null)
{
rows["PRODUCT_NAME"] = product.NAME;
rows["SPEC"] = product.SPEC;
rows["MODEL_NUMBER"] = product.MODEL_NUMBER;
}
}
rows["QUANTITY"] = OLModel.QUANTITY;
rows["PRICE"] = OLModel.PRICE;
rows["AMOUNT_WITHOUT_TAX"] = Convert.ToDouble(CConvert.ToDecimal(rows["QUANTITY"]) * CConvert.ToDecimal(rows["PRICE"])).ToString("0.00");
//rows["AMOUNT_INCLUDED_TAX"] = OLModel.AMOUNT_INCLUDED_TAX;
rows["DUE_DATE"] = CConvert.ToDateTime(purchase.DUE_DATE).ToString("yyyy/MM/dd");
amount += OLModel.AMOUNT_WITHOUT_TAX;
taxAmount += OLModel.TAX_AMOUNT;
dt.Rows.Add(rows);
}
ht.Add("&AMOUNT", amount);
ht.Add("&TAX_AMOUNT", taxAmount);
ht.Add("&TOTAL_AMOUNT", amount + taxAmount);
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "LZ_PURCHASE_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
if (sf.ShowDialog(this) == DialogResult.OK)
{
if (dt.Rows.Count > 0)
{
int ret = CommonExport.ExportPurchase(@"rpt\purchase.xls", sf.FileName, dt, ht);
if (CConstant.EXPORT_FAILURE.Equals(ret))
{
MessageBox.Show("导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_SUCCESS.Equals(ret))
{
MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (CConstant.EXPORT_RUNNING.Equals(ret))
{
MessageBox.Show("文件正在运行，重新生成文件失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_TEMPLETE_FILE_NOT_EXIST.Equals(ret))
{
MessageBox.Show("模版文件不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("明细信息不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
#endregion
}
else
{
decimal AMOUNT_WITHOUT_TAX = 0;
decimal ORDER_AMOUNT = 0;
#region 国外
ht = new Hashtable();
ht.Add("&SUPPLIER_NAME", supplier.NAME);
ht.Add("&CONTACT_NAME", supplier.CONTACT_NAME);
ht.Add("&PHONE", supplier.PHONE_NUMBER);
ht.Add("&FAX", supplier.FAX_NUMBER);
// ht.Add("&ORDER_NUMBER", purchase.ORDER_SLIP_NUMBER);
ht.Add("&SLIP_NUMBER", purchase.SLIP_NUMBER);
ht.Add("&SUPPLIER_ORDER_CODE", purchase.SUPPLIER_ORDER_NUMBER);
ht.Add("&PURCHASE_QUOTATION_NUMBER", purchase.PURCHASE_QUOTATION_NUMBER);
if (order != null)
{
ht.Add("&CUSTOMER_PO_NUMBER", order.CUSTOMER_PO_NUMBER);
string customerCode = "";
//if (!string.IsNullOrEmpty(order.CUSTOMER_NAME))
//{
// customerCode = order.CUSTOMER_CODE;
// ht.Add("&CUSTOMER_NAME", order.CUSTOMER_NAME);
//}
//else
//{
customerCode = order.ENDER_CUSTOMER_CODE;
ht.Add("&CUSTOMER_NAME", order.ENDER_CUSTOMER_NAME);
//}
ht.Add("&DELIVERY_DATE", order.DUE_DATE);
ht.Add("&SERIAL_NUMBER", order.SERIAL_NUMBER);
ht.Add("&AIRCRAFT", order.SERIAL_TYPE);
BaseCustomerTable customer = new BCustomer().GetModel(customerCode);
ht.Add("&CUSTOMER_CONTACT_NAME", customer.CONTACT_NAME);
ht.Add("&CUSTOMER_PHONE", customer.PHONE_NUMBER);
//ht.Add("&ORDER_AMOUNT", order.AMOUNT_INCLUDED_TAX);
}
else
{
ht.Add("&CUSTOMER_PO_NUMBER", "");
ht.Add("&DELIVERY_DATE", "");
ht.Add("&SERIAL_NUMBER", "");
//ht.Add("&ORDER_AMOUNT", "");
ht.Add("&AIRCRAFT", "");
ht.Add("&CUSTOMER_NAME", company.NAME_SHORT);
ht.Add("&CUSTOMER_CONTACT_NAME", "");
ht.Add("&CUSTOMER_PHONE", company.PHONE_NUMBER);
}
ht.Add("&MEMO", purchase.MEMO);
ht.Add("&TOTAL_AMOUNT", purchase.TOTAL_AMOUNT);
ht.Add("&PAYMENT", purchase.PAYMENT_CONDITION);
ht.Add("&SLIP_DATE", purchase.SLIP_DATE);
ht.Add("&DUE_DATE", purchase.DUE_DATE);
dt = new DataTable();
dt.Columns.Add("NO");
dt.Columns.Add("PRODUCT_CODE");
dt.Columns.Add("X_1", Type.GetType("System.String"));
dt.Columns.Add("PRODUCT_NAME");
dt.Columns.Add("X_2", Type.GetType("System.String"));
dt.Columns.Add("MODEL_NUMBER");
dt.Columns.Add("X_3", Type.GetType("System.String"));
dt.Columns.Add("QUANTITY");
dt.Columns.Add("PRICE");
dt.Columns.Add("AMOUNT_WITHOUT_TAX");
DataRow rows = null;
foreach (BllPurchaseOrderLineTable OLModel in purchase.Items)
{
AMOUNT_WITHOUT_TAX += OLModel.AMOUNT_INCLUDED_TAX;
if (order != null)
{
foreach (BllOrderLineTable line in order.Items)
{
if (line.PRODUCT_CODE == OLModel.PRODUCT_CODE)
{
ORDER_AMOUNT += CConvert.ToDecimal(line.AMOUNT);
break;
}
}
}
else
{
ORDER_AMOUNT += 0;
}
rows = dt.NewRow();
rows["NO"] = OLModel.LINE_NUMBER;
rows["PRODUCT_CODE"] = OLModel.PRODUCT_CODE;
if (OLModel.PRODUCT_CODE.Length >= 4 && OLModel.PRODUCT_CODE.Substring(0, 4) == "9999")
{
rows["PRODUCT_NAME"] = OLModel.PRODUCT_NAME;
rows["MODEL_NUMBER"] = OLModel.PRODUCT_SPEC;
}
else
{
BaseProductTable product = new BProduct().GetModel(OLModel.PRODUCT_CODE);
if (product != null)
{
if (!string.IsNullOrEmpty(product.NAME_JP))
{
rows["PRODUCT_NAME"] = product.NAME_JP;
}
else
{
rows["PRODUCT_NAME"] = product.NAME;
}
rows["MODEL_NUMBER"] = product.SPEC + " " + product.MODEL_NUMBER;
}
}
rows["QUANTITY"] = OLModel.QUANTITY;
rows["PRICE"] = OLModel.PRICE;
rows["AMOUNT_WITHOUT_TAX"] = OLModel.AMOUNT_INCLUDED_TAX;
dt.Rows.Add(rows);
}
ht.Add("&AMOUNT_WITHOUT_TAX", AMOUNT_WITHOUT_TAX);
ht.Add("&ORDER_AMOUNT", ORDER_AMOUNT);
SaveFileDialog sf = new SaveFileDialog();
sf.FileName = "LZ_PURCHASE_OVERSEAS_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
sf.Filter = "(文件)|*.xls;*.xlsx";
if (sf.ShowDialog(this) == DialogResult.OK)
{
if (dt.Rows.Count > 0)
{
int ret = CommonExport.ExportPurchaseOverseas(@"rpt\purchase_overseas.xls", sf.FileName, dt, ht);
if (CConstant.EXPORT_FAILURE.Equals(ret))
{
MessageBox.Show("导出失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_SUCCESS.Equals(ret))
{
MessageBox.Show("导出成功。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (CConstant.EXPORT_RUNNING.Equals(ret))
{
MessageBox.Show("文件正在运行，重新生成文件失败。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (CConstant.EXPORT_TEMPLETE_FILE_NOT_EXIST.Equals(ret))
{
MessageBox.Show("模版文件不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("明细信息不存在。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
#endregion
}
}
else
{
MessageBox.Show("请选择一行!");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BaseWarehouseTable model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BaseWarehouseTable model)
{
return(dal.Add(model));
}
