private void textBoxContainButton1_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=ShippingAddress_ID,Desc_01=Desc_01 ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1("ShippingAddress", _columns, "And isnull(ShippingAddress_Id,'')<>'" + this.txtDepNo.Text + "'");
}
else
{
string _where = "and ShippingAddress.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And isnull(ShippingAddress_Id,'')<>'" + this.txtDepNo.Text + "'";
_ht = CommomHelper.GetQuery1("ShippingAddress", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNo.Text))
{
MessageBox.Show("物料单位编码不能为空！");
return;
}
if (_Edit == "ADD")
{
string _where = " And isnull(ItemUt_Id,'')='" + this.txtNo.Text + "'";
if (!CommomHelper.Exists("ItemUt", _where))
{
if (AddItemUt())
{
this.DialogResult = DialogResult.Yes;
}
}
else
{
MessageBox.Show("该物料单位已存在！");
return;
}
}
else if (_Edit == "UPD")
{
if (UpdateItemUt())
{
this.DialogResult = DialogResult.Yes;
}
}
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public long UpdateUserInfo(UserInfoDTO userInfo)
{
using (B2CDbContext ctx = new B2CDbContext())
{
BaseService <UserInfoEntity> bs = new BaseService <UserInfoEntity>(ctx);
var dbUser = bs.GetById(userInfo.Id);
dbUser.Address = userInfo.Address;
dbUser.Email = userInfo.Email;
dbUser.Gender = userInfo.Gender;
dbUser.IDCardNo = userInfo.IDCardNo;
dbUser.Money = userInfo.Money;
dbUser.PassQuestion = userInfo.PassQuestion;
dbUser.PassAnswer = userInfo.PassAnswer;
dbUser.PhoneNumber = userInfo.PhoneNumber;
dbUser.RoleInfoId = userInfo.RoleId;
dbUser.UserStateId = userInfo.UserStateId;
dbUser.UserName = userInfo.UserName;
string hash = CommomHelper.CalcMD5(dbUser.PassWordSalt + userInfo.Password);
dbUser.PassWordHash = hash;
dbUser.CardTypes.Clear();
var atts = ctx.CardType.Where(a => a.IsDelete == false &&
userInfo.CardTypeIds.Contains(a.Id));
foreach (var item in atts)
{
dbUser.CardTypes.Add(item);
}
ctx.SaveChanges();
return(dbUser.Id);
}
}
public void InitializeFriends(string myNickName)
{
_client = ServiceProvider.Clent;
OnlineCount = 0;
Friends.Clear();
TEmployeeDTO[] result = _client.TEmployeeQueryAll();
Array.ForEach(result, t => {
FriendData data = new FriendData();
data.Image = t.EntryImage;
data.Name = t.EmployeeName;
data.Data = t;
TLoginDTO login = _client.TLoginQueryById(t.EmployeeId);
data.State = CommomHelper.ParseState(login.State);
data.Order = login.State;
if (t.EmployeeName == myNickName)
{
data.Order = 1;
data.State = FriendState.Online;
}
data.Emotion = t.Emotion;
FriendInfo info = new FriendInfo(data);
info.Width = this.Width;
info.Click += info_Click;
info.ChangedState += info_ChangedState;
info.DoubleClick += info_DoubleClick;
Friends.Add(t.EmployeeName, info);
});
OrderList();
}
private void textBoxContainButton1_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=ProjectStage_Id,Desc_01=Desc_01 ";
string _where = "AND isnull(ProjectStage_Id,'')<>'" + this.txtNo.Text + "'";
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1("ProjectStage", _columns, _where);
}
else
{
_ht = CommomHelper.GetQuery1("ProjectStage", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void textBoxContainButton2_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
string _columns = " ID=Role_ID,Desc_01=Desc_01 ";
_ht = CommomHelper.GetQuery1("Role", _columns, "");
}
else
{
string _columns = " ID=Role_ID,Desc_01=Role_ID ";
string _where = "and UsrRole.Usr_id='" + LoginInfo._Usr_id + "'";
_ht = CommomHelper.GetQuery1("UsrRole", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void textBoxContainButton1_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=Warehouse_Id,Desc_01=Desc_01 ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1("Warehouse", _columns, "and Warehouse_Id not in('" + this.txtNo.Text + "') ");
}
else
{
string _where = "and Warehouse.Company_Id='" + LoginInfo._Usr_Company + "' and Warehouse_Id not in('" + this.txtNo.Text + "')";
_ht = CommomHelper.GetQuery1("Warehouse", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtDepNo.Text))
{
MessageBox.Show("部门编码不能为空！");
return;
}
if (_Edit == "ADD")
{
string _where = "and ShippingAddress.Company_Id='" + LoginInfo._Usr_Company + "' And isnull(ShippingAddress_Id,'')='" + this.txtDepNo.Text + "'";
if (!CommomHelper.Exists("ShippingAddress", _where))
{
if (AddShippingAddress())
{
this.DialogResult = DialogResult.Yes;
}
}
else
{
MessageBox.Show("该地址已存在！");
return;
}
}
else if (_Edit == "UPD")
{
if (UpdShippingAddress())
{
this.DialogResult = DialogResult.Yes;
}
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNo.Text))
{
MessageBox.Show("仓库/仓位编码不能为空！");
return;
}
if (_Edit == "ADD")
{
string _where = "and Warehouse.Company_Id='" + LoginInfo._Usr_Company + "' And isnull(Warehouse_Id,'')='" + this.txtNo.Text + "'";
if (!CommomHelper.Exists("Warehouse", _where))
{
if (AddWarehouse())
{
this.DialogResult = DialogResult.Yes;
}
}
else
{
MessageBox.Show("该仓库/仓位已存在！");
return;
}
}
else if (_Edit == "UPD")
{
if (UpdateWarehouse())
{
this.DialogResult = DialogResult.Yes;
}
}
}
private void textBoxContainButton2_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=Employee_ID,Desc_01=Desc_01 ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
string PgmName = "Employee";
if (_txt.Name == "Recipient_Employee_Ids" || _txt.Name == "CC_Employee_Ids")
{
PgmName = "Employee_MutSelect";
}
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1(PgmName, _columns, "");
}
else
{
string _where = "and Employee.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130'))";
_ht = CommomHelper.GetQuery1(PgmName, _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
/// <summary>
/// 填写用户信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public long AddUserInfo(UserInfoDTO userInfo)
{
using (B2CDbContext ctx = new B2CDbContext())
{
BaseService <CardTypeEntity> cardType
= new BaseService <CardTypeEntity>(ctx);
UserInfoEntity userInfoEntity = new UserInfoEntity();
userInfoEntity.Address = userInfo.Address;
userInfoEntity.Email = userInfo.Email;
userInfoEntity.Gender = userInfo.Gender;
userInfoEntity.IDCardNo = userInfo.IDCardNo;
userInfoEntity.Money = userInfo.Money;
userInfoEntity.PassAnswer = userInfo.PassAnswer;
userInfoEntity.PassQuestion = userInfo.PassQuestion;
string salt = CommomHelper.CreateVerifyCode(5);
string hash = CommomHelper.CalcMD5(salt + userInfo.Password);
userInfoEntity.PassWordSalt = salt;
userInfoEntity.PassWordHash = hash;
userInfoEntity.PhoneNumber = userInfo.PhoneNumber;
userInfoEntity.RoleInfoId = userInfo.RoleId;
userInfoEntity.UserName = userInfo.UserName;
userInfoEntity.UserStateId = userInfo.UserStateId;
foreach (var item in cardType.GetAll().Where(a => userInfo.CardTypeIds.Contains(a.Id)))
{
userInfoEntity.CardTypes.Add(item);
}
ctx.UserInfos.Add(userInfoEntity);
ctx.SaveChanges();
return(userInfoEntity.Id);
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNo.Text))
{
MessageBox.Show("阶段编码不能为空！");
return;
}
if (_Edit == "ADD")
{
string _where = "and isnull(ProjectStage_Id,'')='" + this.txtNo.Text + "'";
if (!CommomHelper.Exists("ProjectStage", _where))
{
if (AddProjectStage())
{
this.DialogResult = DialogResult.Yes;
}
}
else
{
MessageBox.Show("该项目阶段编码已存在！");
return;
}
}
else if (_Edit == "UPD")
{
if (UpdateProjectStage())
{
this.DialogResult = DialogResult.Yes;
}
}
}
private void textBoxContainButton3_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=ItemKind_ID,Desc_01=Desc_01 ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1("ItemKind", _columns, " And (Status_Id In ('130', '130')) ");
}
else
{
string _where = "and Department.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130'))";
_ht = CommomHelper.GetQuery1("ItemKind", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void textBoxContainButton1_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=Notify_Id,Desc_01=Notify_Id ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
if (LoginInfo._ZT_Admin_Id == "Z")
{
_ht = CommomHelper.GetQuery1("TaskNotifyOrder", _columns, "");
}
else
{
string _where = "and TaskNotifyOrder.Company_Id='" + LoginInfo._Usr_Company + "'";
_ht = CommomHelper.GetQuery1("TaskNotifyOrder", _columns, _where);
}
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void BtnOk_Click(object sender, EventArgs e)
{
DataTable _dtnew = new DataTable();
BindingSource _bdSource = new BindingSource();
_bdSource = dataGridView1.DataSource as BindingSource;
if (_bdSource != null)
{
try
{
_dtEwm = _bdSource.DataSource as DataTable;
#region 表身二维码
StringBuilder strSqlBodyEwm = new StringBuilder();
if (_dtEwm != null)
{
for (int i = 0; i < _dtEwm.Rows.Count; i++)
{
strSqlBodyEwm.Append("insert into [" + _Body1_Tbl_Name + "] (");
strSqlBodyEwm.Append("Company_Id,Shipping_Id,Itm_Full_Id,Scan_Ewm_Id,Po_Itm,Xm_Id,Item_Desc,Shipping_Address,Qty_Shipping,Available_Qty_Serial_Id,Manufacturer_Id,Serial_Id,AQID,");
strSqlBodyEwm.Append(" PurType_Id,Qty_Po,Planning_Shipping_Date,Already_Shipping_Id,Shipping_Date,Planning_Arrive_Date,Carrier_Id,Lading_Shipping_Id,BarCode_Print_Qty,ItemPrpty_Id_Before,");
strSqlBodyEwm.Append(" ItemSerial_Id_Before,AQID_Before,CsvPo_Id,ItemPrpty_Id,V,APO)");
strSqlBodyEwm.Append("VALUES(@Company_Id,@Shipping_Id,'" + _dtEwm.Rows[i]["Itm_Full_Id"].ToString() + "','" + _dtEwm.Rows[i]["Scan_Ewm_Id"].ToString() + "',");
strSqlBodyEwm.Append(+CommomHelper.ToInt(_dtEwm.Rows[i]["Po_Itm"].ToString()) + ",'" + _dtEwm.Rows[i]["Xm_Id"].ToString() + "','" + _dtEwm.Rows[i]["Item_Desc"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["Shipping_Address"].ToString() + "'," + CommomHelper.ToDecimal(_dtEwm.Rows[i]["Qty_Shipping"].ToString()) + ",'" + _dtEwm.Rows[i]["Available_Qty_Serial_Id"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["Manufacturer_Id"].ToString() + "','" + _dtEwm.Rows[i]["Serial_Id"].ToString() + "','" + _dtEwm.Rows[i]["AQID"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["PurType_Id"].ToString() + "'," + CommomHelper.ToDecimal(_dtEwm.Rows[i]["Qty_Po"].ToString()) + ",'" + _dtEwm.Rows[i]["Planning_Shipping_Date"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["Already_Shipping_Id"].ToString() + "','" + _dtEwm.Rows[i]["Shipping_Date"].ToString() + "','" + _dtEwm.Rows[i]["Planning_Arrive_Date"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["Carrier_Id"].ToString() + "','" + _dtEwm.Rows[i]["Lading_Shipping_Id"].ToString() + "'," + CommomHelper.ToDecimal(_dtEwm.Rows[i]["BarCode_Print_Qty"].ToString()) + ",");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["ItemPrpty_Id_Before"].ToString() + "','" + _dtEwm.Rows[i]["ItemSerial_Id_Before"].ToString() + "','" + _dtEwm.Rows[i]["AQID_Before"].ToString() + "','" + _dtEwm.Rows[i]["CsvPo_Id"].ToString() + "',");
strSqlBodyEwm.Append("'" + _dtEwm.Rows[i]["ItemPrpty_Id"].ToString() + "','" + _dtEwm.Rows[i]["V"].ToString() + "','" + _dtEwm.Rows[i]["APO"].ToString() + "')");
}
}
SqlParameter[] parameters =
{
new SqlParameter("@Company_Id", SqlDbType.NVarChar, 50),
new SqlParameter("@Shipping_Id", SqlDbType.NVarChar, 50)
};
parameters[0].Value = _Company_Id;
parameters[1].Value = _Shipping_Id;
#endregion
bool IsTrue = SqlHelper.ExecuteQueryTrans(strSqlBodyEwm.ToString(), parameters);
if (IsTrue)
{
this.DialogResult = DialogResult.Yes;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("表身二维码未生成！");
}
}
private void textBoxContainButton2_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=Collection_Id,Desc_01=Collection_Id ";
Dictionary <string, object> _ht = CommomHelper.GetQuery1("RequestCollectionOrder", _columns, "");
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
private void textBoxContainButton2_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
if (LoginInfo._ZT_Admin_Id == "Z")
{
_txt.Text = CommomHelper.GetQuery("Role", "");
}
else
{
string _where = "and UsrRole.Usr_id='" + LoginInfo._Usr_id + "'";
_txt.Text = CommomHelper.GetQuery("UsrRole", _where);
}
}
private void BtnDel_Click(object sender, EventArgs e)
{
if (this.dataGridView1 != null && this.dataGridView1.Rows.Count > 0)
{
if (dataGridView1.CurrentRow != null)
{
DataGridViewRow _dr = this.dataGridView1.Rows[dataGridView1.CurrentRow.Index];
if (_dr != null)
{
string _Company_Id = string.IsNullOrEmpty(_dr.Cells["Company_Id"].Value.ToString()) ? "" : (_dr.Cells["Company_Id"].Value.ToString()).ToString();
string _Notify_Id = string.IsNullOrEmpty((_dr.Cells["Notify_Id"].Value.ToString()).ToString()) ? "" : (_dr.Cells["Notify_Id"].Value.ToString()).ToString();
if (!CommomHelper.ChkDel("确认删除单据[" + _Notify_Id + "]?"))
{
return;
}
try
{
string insertWhere = " Where 1=1 and Company_Id='" + LoginInfo._Usr_Company + "' and Notify_Id='" + _Notify_Id + "'";
InsertDataForTemp(insertWhere);
bool _delOk = false;
if (DelteAudit(_Company_Id, _Notify_Id))
{
_delOk = Delete(_Company_Id, _Notify_Id);
}
if (_delOk)
{
StringBuilder strGetIdSql = new StringBuilder();
strGetIdSql.Append(" Exec dbo.usp_DelBilId1 ");
strGetIdSql.Append(" @Company_Id='" + LoginInfo._Usr_Company + "', ");
strGetIdSql.Append(" @Pgm_Tag_Id='TN', ");
strGetIdSql.Append(" @Bill_Date='" + System.DateTime.Now.ToShortDateString() + "', ");
strGetIdSql.Append(" @Serial_Number=1 , ");
strGetIdSql.Append(" @Bil_Id='" + _Notify_Id + "' ");
DataTable _dtRusult = SqlHelper.ExecuteDataTable(strGetIdSql.ToString());
string _where = " Where 1=1 and Company_Id='" + LoginInfo._Usr_Company + "'";
QueryData(_where);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
}
private void textBoxContainButton1_Click(object sender, EventArgs e)
{
TextBoxContainButton _txt = (TextBoxContainButton)sender;
string _columns = " ID=ItemUt_ID,Desc_01=Desc_01 ";
Dictionary <string, object> _ht = new Dictionary <string, object>();
_ht = CommomHelper.GetQuery1("ItemUt", _columns, "");
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
_txt.ID = _ht["ID"].ToString();
_txt.Desc = _ht["DESC"].ToString();
_txt.Text = _ht["DESC"].ToString();
}
}
}
private void UpdateViewItem(TDataInfoDTO dto, ListViewItemEx lvi)
{
lvi.Text = dto.DataName;
lvi.ItemData = dto;
if (dto.IsForlder == false)
{
string tempFileExtension = Path.GetExtension(dto.DataName);
lvi.ImageIndex = CommomHelper.GetImageIndex(dto, imageList1);
lvi.ToolTipText = string.Format("文件名称:{0}\r\n文件大小:{1}M\r\n上传时间:{2}\r\n上传人:{3}\r\n修改时间:{4}\r\n下载次数:{5}\r\n文件描述:{6}", dto.DataName, CommomHelper.ParseMB(dto.FileSize), dto.CreateTime, dto.UploadPeople, dto.LastModifyTime, dto.DownloadTimes, dto.DataDescription);
}
else
{
if (!imageList1.Images.Keys.Contains("Folder"))
{
imageList1.Images.Add("Folder", Resources.folder);
}
lvi.ImageIndex = imageList1.Images.Keys.IndexOf("Folder");
string.Format("文件名称:{0}\r\n上传时间:{1}\r\n上传人:{2}\r\n修改时间:{3}\r\n文件描述:{4}", dto.DataName, dto.CreateTime, dto.UploadPeople, dto.LastModifyTime, dto.DataDescription);
}
}
public int Compare(object x, object y)
{
ListViewItemEx y1 = (ListViewItemEx)x;
ListViewItemEx x1 = (ListViewItemEx)y;
if (x1.ItemData == null || y1.ItemData == null)
{
return(1);
}
if (x1.ItemData.IsForlder)
{
return(-1);
}
else if (y1.ItemData.IsForlder)
{
return(1);
}
else
{
return((int)(CommomHelper.ParseMB(x1.ItemData.FileSize) - CommomHelper.ParseMB(y1.ItemData.FileSize)));
}
}
public void UploadFile(string filePath, string parentId, ImageList lstImage)
{
_saveHistory = filePath;
try
{
TDataInfoDTO uploadDTO = new TDataInfoDTO();
uploadDTO.MetaDataId = Guid.NewGuid().ToString();
uploadDTO.DataName = Path.GetFileName(filePath);
uploadDTO.DownloadTimes = 0;
uploadDTO.LastModifyTime = DateTime.Now;
uploadDTO.CreateTime = DateTime.Now;
uploadDTO.BaseInfoId = _baseId;
uploadDTO.UploadPeople = CommonData.LoginInfo.EmployeeName;
FileInfo info = new FileInfo(filePath);
uploadDTO.FileSize = info.Length.ToString();
uploadDTO.IsForlder = false;
uploadDTO.ParentId = parentId;
bool success = _client.TDataInfoAdd(uploadDTO);
if (success && !_bgwork.IsBusy)
{
this.ToolTipText = string.Format("文件名称:{0}\r\n文件大小:{1}M\r\n上传时间:{2}\r\n上传人:{3}\r\n修改时间:{4}\r\n下载次数:{5}\r\n文件描述:{6}", uploadDTO.DataName, CommomHelper.ParseMB(uploadDTO.FileSize), uploadDTO.CreateTime, uploadDTO.UploadPeople, uploadDTO.LastModifyTime, uploadDTO.DownloadTimes, uploadDTO.DataDescription);
this.SubItems.Add(uploadDTO.DataName);
this.SubItems.Add(CommomHelper.ParseMB(uploadDTO.FileSize) + "M");
this.SubItems.Add(uploadDTO.LastModifyTime.Value.ToString());
this.SubItems.Add(uploadDTO.UploadPeople);
this.ImageIndex = CommomHelper.GetImageIndex(filePath, uploadDTO.MetaDataId, lstImage);
ItemData = uploadDTO;
byte[] buffer = IOHelper.GetStreamBuffer(filePath);
OpareteType = OpareteTypeEnum.Upload;
ShowProgressBar();
_bgwork.RunWorkerAsync(new object[] { buffer, uploadDTO.MetaDataId });
}
}
catch (Exception)
{
throw;
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
DataGridViewColumn _column = dataGridView1.Columns[e.ColumnIndex];
BindingSource _bdSource = new BindingSource();
_bdSource = dataGridView1.DataSource as BindingSource;
if (_column.DataPropertyName == "ItemUnit_Id")
{
string _columns = " ID=ItemUt_ID,Desc_01=Desc_01 ";
string _where = "and (Status_Id In ('130', '130')) and ItemUt_Id not in ('" + _ItemUtId + "')";
Dictionary <string, object> _ht = CommomHelper.GetQuery1("ItemUt", _columns, _where);
if (_ht != null)
{
if (_ht.ContainsKey("ID") && _ht.ContainsKey("DESC"))
{
this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = _ht["ID"].ToString();
_bdSource.EndEdit();
}
}
}
}
}
private void CreateViewItem(TDataInfoDTO dto, int index, bool edit = false)
{
ListViewItemEx lvi = new ListViewItemEx();
lvi.ItemData = dto;
lvi.Text = dto.DataName;
if (dto.IsForlder == false)
{
lvi.ImageIndex = CommomHelper.GetImageIndex(dto, imageList1);
lvi.ToolTipText = string.Format("文件名称:{0}\r\n文件大小:{1}M\r\n上传时间:{2}\r\n上传人:{3}\r\n修改时间:{4}\r\n下载次数:{5}\r\n文件描述:{6}", dto.DataName, CommomHelper.ParseMB(dto.FileSize), dto.CreateTime, dto.UploadPeople, dto.LastModifyTime, dto.DownloadTimes, dto.DataDescription);
lvi.SubItems.Add(dto.DataName);
lvi.SubItems.Add(CommomHelper.ParseMB(dto.FileSize) + "M");
lvi.SubItems.Add(dto.LastModifyTime.Value.ToString());
lvi.SubItems.Add(dto.UploadPeople);
LvDataContent.Items.Insert(index, lvi);
//lvi.SetOtherControl();
}
else
{
if (!imageList1.Images.Keys.Contains("Folder"))
{
imageList1.Images.Add("Folder", Resources.folder);
}
lvi.ImageIndex = imageList1.Images.Keys.IndexOf("Folder");
string.Format("文件名称:{0}\r\n上传时间:{1}\r\n上传人:{2}\r\n修改时间:{3}\r\n文件描述:{4}", dto.DataName, dto.CreateTime, dto.UploadPeople, dto.LastModifyTime, dto.DataDescription);
lvi.SubItems.Add(dto.DataName);
lvi.SubItems.Add(CommomHelper.ParseMB(dto.FileSize) + "M");
lvi.SubItems.Add(dto.LastModifyTime.Value.ToString());
lvi.SubItems.Add(dto.UploadPeople);
LvDataContent.Items.Insert(index, lvi);
}
if (edit)
{
lvi.BeginEdit();
}
}
private void _bgwork_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if ((bool)e.Result == false)
{
ReportError();
}
else
{
Hide();
if (OpareteType == OpareteTypeEnum.Download)
{
ItemData.DownloadTimes += 1;
bool success = _client.TDataInfoUpdate(ItemData);
if (success)
{
this.ToolTipText = string.Format("文件名称:{0}\r\n文件大小:{1}M\r\n上传时间:{2}\r\n上传人:{3}\r\n修改时间:{4}\r\n下载次数:{5}\r\n文件描述:{6}", ItemData.DataName, CommomHelper.ParseMB(ItemData.FileSize), ItemData.CreateTime, ItemData.UploadPeople, ItemData.LastModifyTime, ItemData.DownloadTimes, ItemData.DataDescription);
}
}
}
}
private bool UpdShippingInfoConfirmOrder()
{
#region 表头
StringBuilder strSql = new StringBuilder();
strSql.Append(" Update ShippingInfoConfirmOrder ");
strSql.Append("set Company_Id='" + _Company_Id + "',");
foreach (Control _ct in tableLayoutPanel1.Controls)
{
if (!(_ct is Label) && !(_ct is Button))
{
if (_ct is TextBoxContainButton)
{
TextBoxContainButton _txtBtn = (TextBoxContainButton)_ct;
string _id = string.IsNullOrEmpty(_txtBtn.ID) ? "" : _txtBtn.ID;
strSql.Append(_ct.Name + "='" + _id + "'");
}
else
{
if (Convert.ToString(_ct.Tag) == "Datatime")
{
strSql.Append(_ct.Name + "='" + Convert.ToDateTime(_ct.Text) + "'");
}
else if (Convert.ToString(_ct.Tag) == "Decimal")
{
strSql.Append(_ct.Name + "='" + CommomHelper.ToDecimal(_ct.Text) + "'");
}
else
{
strSql.Append(_ct.Name + "='" + _ct.Text + "'");
}
}
strSql.Append(",");
}
}
strSql.Append(" Pgm_Tag_Id='SC' ");
strSql.Append(" where Shipping_Id='" + this.Shipping_Id.Text + "' and Company_Id='" + _Company_Id + "' ");
#endregion
#region 表身
BindingSource _bdSource = new BindingSource();
_bdSource = dataGridView1.DataSource as BindingSource;
DataTable _dtBody = _bdSource.DataSource as DataTable;
StringBuilder strSqlBody = new StringBuilder();
if (_dtBody != null)
{
for (int i = 0; i < _dtBody.Rows.Count; i++)
{
if (string.IsNullOrEmpty(_dtBody.Rows[i]["Itm_Full_Id"].ToString()))
{
#region 表身新增列
string _ColumnValue = "";
strSqlBody.Append("If ((select 1 from ShippingInfoConfirmBody where Shipping_Id='" + this.Shipping_Id.Text + "' and Company_Id='" + _Company_Id + "') is null) ");
strSqlBody.Append("insert into ShippingInfoConfirmBody(Company_Id,");
for (int j = 0; j < _dtBody.Columns.Count; j++)
{
string _ColumnName = _dtBody.Columns[j].ColumnName;
if (_ColumnName == "Company_Id" || _ColumnName == "Ewm_Id" || _ColumnName == "Itm_Full_Id" || _ColumnName == "Shipping_Id" || _ColumnName == "Company__Id" || _ColumnName == "Itm_Full_Id" ||
_ColumnName == "Role__Id" || _ColumnName == "Usr__Id" || _ColumnName == "Create__Date" || _ColumnName == "Pgm_Id" ||
_ColumnName == "Last_Modify_Company_Id" || _ColumnName == "Last_Modify_Role_Id" || _ColumnName == "Last_Modify_Usr_Id" || _ColumnName == "Last_Modify_Date")
{
continue;
}
strSqlBody.Append(_dtBody.Columns[j].ColumnName);
strSqlBody.Append(",");
}
strSqlBody.Append("Shipping_Id,Itm_Full_Id,Company__Id,Role__Id,Usr__Id,Create__Date)");
strSqlBody.Append("VALUES(");
strSqlBody.Append("'" + LoginInfo._Usr_Company + "',");
for (int j = 0; j < _dtBody.Columns.Count; j++)
{
string _ColumnName = _dtBody.Columns[j].ColumnName;
if (_ColumnName == "Company_Id" || _ColumnName == "Ewm_Id" || _ColumnName == "Itm_Full_Id" || _ColumnName == "Shipping_Id" || _ColumnName == "Company__Id" || _ColumnName == "Itm_Full_Id" ||
_ColumnName == "Role__Id" || _ColumnName == "Usr__Id" || _ColumnName == "Create__Date" || _ColumnName == "Pgm_Id" ||
_ColumnName == "Last_Modify_Company_Id" || _ColumnName == "Last_Modify_Role_Id" || _ColumnName == "Last_Modify_Usr_Id" || _ColumnName == "Last_Modify_Date")
{
continue;
}
_ColumnValue = _dtBody.Rows[i][j].ToString();
if (_dtBody.Columns[j].DataType == (new DateTime()).GetType())
{
if (string.IsNullOrEmpty(_ColumnValue))
{
_ColumnValue = System.DateTime.Now.ToString();
}
strSqlBody.Append("'");
strSqlBody.Append(Convert.ToDateTime(_ColumnValue));
strSqlBody.Append("',");
}
else if (_dtBody.Columns[j].DataType == (new Decimal()).GetType() || (_dtBody.Columns[j].DataType == (new int()).GetType()))
{
strSqlBody.Append(CommomHelper.ToDecimal(_ColumnValue));
strSqlBody.Append(",");
}
else
{
strSqlBody.Append("'");
strSqlBody.Append(_ColumnValue);
strSqlBody.Append("',");
}
}
strSqlBody.Append("'" + this.Shipping_Id.Text + "',Replace(Cast(NewId() As nvarchar(50)),'-','')," + "'" + LoginInfo._Usr_Company + "','" + LoginInfo._Usr_Role + "','" + LoginInfo._Usr_id + "', '" + System.DateTime.Now.ToString() + "')");
#endregion
}
else
{
#region 修改表身列
string _ColumnValue = "";
strSqlBody.Append("Update ShippingInfoConfirmBody set Company_Id='" + LoginInfo._Usr_Company + "',");
for (int j = 0; j < _dtBody.Columns.Count; j++)
{
string _ColumnName = _dtBody.Columns[j].ColumnName;
if (_ColumnName == "Company_Id" || _ColumnName == "Ewm_Id" || _ColumnName == "Itm_Full_Id" || _ColumnName == "Shipping_Id" || _ColumnName == "Company__Id" || _ColumnName == "Itm_Full_Id" ||
_ColumnName == "Role__Id" || _ColumnName == "Usr__Id" || _ColumnName == "Create__Date" || _ColumnName == "Pgm_Id" ||
_ColumnName == "Last_Modify_Company_Id" || _ColumnName == "Last_Modify_Role_Id" || _ColumnName == "Last_Modify_Usr_Id" || _ColumnName == "Last_Modify_Date")
{
continue;
}
_ColumnValue = _dtBody.Rows[i][j].ToString();
if (_dtBody.Columns[j].DataType == (new DateTime()).GetType())
{
strSqlBody.Append(_dtBody.Columns[j].ColumnName + "='" + Convert.ToDateTime(_ColumnValue) + "'");
}
else if (_dtBody.Columns[j].DataType == (new Decimal()).GetType() || (_dtBody.Columns[j].DataType == (new int()).GetType()))
{
strSqlBody.Append(_dtBody.Columns[j].ColumnName + "=" + CommomHelper.ToDecimal(_ColumnValue) + "");
}
else
{
strSqlBody.Append(_dtBody.Columns[j].ColumnName + "='" + _ColumnValue + "'");
}
strSqlBody.Append(",");
}
strSqlBody.Append(" Last_Modify_Company_Id='" + LoginInfo._Usr_Company + "',Last_Modify_Role_Id='" + LoginInfo._Usr_Role + "',Last_Modify_Usr_Id='" +
LoginInfo._Usr_id + "',Last_Modify_Date='" + System.DateTime.Now.ToString() + "'");
strSqlBody.Append(" where Shipping_Id='" + this.Shipping_Id.Text + "' and Company_Id='" + LoginInfo._Usr_Company + "' ");
strSqlBody.Append(" and Itm_Full_Id='" + _dtBody.Rows[i]["Itm_Full_Id"].ToString() + "' ");
#endregion
}
}
}
#endregion
#region Body1
StringBuilder _strSqlBody1 = new StringBuilder();
_strSqlBody1.Append(" Update TempBody1 Set Company_Id='" + LoginInfo._Usr_Company + "', Shipping_Id='" + this.Shipping_Id.Text + "' ");
_strSqlBody1.Append(" From [" + Body1_Tbl_Name + "] TempBody1 ");
_strSqlBody1.Append(" Delete From ShippingInfoConfirmBody1 ");
_strSqlBody1.Append(" Where ShippingInfoConfirmBody1.Company_Id='" + LoginInfo._Usr_Company + "' ");
_strSqlBody1.Append(" And ShippingInfoConfirmBody1.Shipping_Id='" + this.Shipping_Id.Text + "' ");
_strSqlBody1.Append(" Insert Into ShippingInfoConfirmBody1 ");
_strSqlBody1.Append(" Select * From [" + Body1_Tbl_Name + "] ");
#endregion
bool IsTrue = SqlHelper.ExecuteQueryTrans(strSql + strSqlBody.ToString() + _strSqlBody1.ToString());
return(IsTrue);
}
void btn_Click(object sender, EventArgs e)
{
int _ColumnIndex = dataGridView1.CurrentCell.ColumnIndex;
int _RowIndex = dataGridView1.CurrentCell.RowIndex;
DataGridViewColumn _column = dataGridView1.Columns[_ColumnIndex];
BindingSource _bdSource = new BindingSource();
_bdSource = dataGridView1.DataSource as BindingSource;
if (_column.DataPropertyName == "Warehouse_Id")
{
string _columns = " ID=Warehouse_Id,Desc_01=Desc_01 ";
string _id = "";
if (LoginInfo._ZT_Admin_Id == "Z")
{
_id = CommomHelper.GetQuery("Warehouse", _columns, "");
}
else
{
string _where = "and Warehouse.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And Is_Lowest='T'";
_id = CommomHelper.GetQuery("Warehouse", _columns, _where);
}
this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id;
_bdSource.EndEdit();
}
else if (_column.DataPropertyName == "Item_Id")
{
string _columns = " ID=Item_Id,Desc_01=Desc_01 ";
string _where = "and Item.Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) And Is_Lowest='T'";
string _id = CommomHelper.GetQuery("Item", _columns, _where);
this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id;
_bdSource.EndEdit();
}
else if (_column.DataPropertyName == "ItemUnit_Id")
{
string _columns = " ID=ItemUnit_Id,Desc_01=ItemUnit_Id ";
// string _where = " And (Status_Id In ('130', '130')) ";
string _id = CommomHelper.GetQuery("ItemUnit", _columns, "");
this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id;
_bdSource.EndEdit();
}
else if (_column.DataPropertyName == "Project_Id")
{
string _columns = " ID=Project_Id,Desc_01=Desc_01 ";
string _where = "and Company_Id='" + LoginInfo._Usr_Company + "' And (Status_Id In ('130', '130')) ";
string _id = CommomHelper.GetQuery("Project", _columns, _where);
this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id;
_bdSource.EndEdit();
}
else if (_column.DataPropertyName == "PackageMethod_Id")
{
string _where = "and (Status_Id In (''130'', ''130'')) ";
string _columns = " ID=PackageMethod_Id,Desc_01=Desc_01 ";
string _id = CommomHelper.GetQuery("PackageMethod", _columns, _where);
this.dataGridView1.Rows[_RowIndex].Cells[_ColumnIndex].Value = _id;
_bdSource.EndEdit();
}
else if (_column.DataPropertyName == "Ewm_Id") //序列号和二维码
{
if (!string.IsNullOrEmpty(this.CsvPo_Id.Text) && !string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString()))
{
ShippingInfoEwmManage _EwmManage = new ShippingInfoEwmManage();
_EwmManage.Edit = _Edit;
_EwmManage.Shipping_Id = this.Shipping_Id.Text;
_EwmManage.Company_Id = LoginInfo._Usr_Company;
_EwmManage.CsvPo_Id = this.CsvPo_Id.Text;
_EwmManage.ItemPrpty_Id = this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString();
_EwmManage.qty = this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString();
_EwmManage.itemUt = String.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemUnit_Id"].Value.ToString()) ? "" : this.dataGridView1.Rows[_RowIndex].Cells["ItemUnit_Id"].Value.ToString();
_EwmManage.Body1_Tbl_Name = Body1_Tbl_Name;
if (_EwmManage.ShowDialog() != DialogResult.OK)
{
}
}
else
{
MessageBox.Show("客户PO和型号必须输入!");
}
}
else if (_column.DataPropertyName == "snc") //SNC导入导出
{
if (string.IsNullOrEmpty(this.CsvPo_Id.Text) || string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString()) || string.IsNullOrEmpty(this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString()))
{
MessageBox.Show("客户PO和型号、数量必须输入!");
return;
}
Form3 f3 = new Form3();
f3.PO = this.CsvPo_Id.Text;
f3.SEL = this.dataGridView1.Rows[_RowIndex].Cells["ItemPrpty_Id"].Value.ToString();
f3.QTY = this.dataGridView1.Rows[_RowIndex].Cells["Qty"].Value.ToString();
f3.input = this.dataGridView1.Rows[_RowIndex].Cells["Src_Input_Id"].Value.ToString();
if (f3.ShowDialog() != DialogResult.OK)
{
}
}
}
/// <summary>
/// 转换为用分隔符拼接的字符串
/// </summary>
/// <typeparam name="T">集合元素类型</typeparam>
/// <param name="list">集合</param>
/// <param name="quotes">引号，默认不带引号，范例：单引号 "'"</param>
/// <param name="separator">分隔符，默认使用逗号分隔</param>
public static string Splice <T>(this IEnumerable <T> list, string quotes = "", string separator = ",")
{
return(CommomHelper.Splice(list, quotes, separator));
}
private bool UpdUsr()
{
string UpdColmn = "Name=@Name,B_Date=@B_Date,E_Date=@E_Date,ZT_Admin_Id=@ZT_Admin_Id,Status_Id=@Status_Id,Usr__Id=@Usr__Id,Role__Id=@Role__Id,Create__Date=@Create__Date,Remark=@Remark";
if (!string.IsNullOrEmpty(this.txtPwd.Text))
{
UpdColmn += ",Pwd=@Pwd ";
}
string _sqlStr = string.Format("Update Usr1 set {0} Where ZT_Id=@ZT_Id and Usr_Id=@Usr_Id ; ",
UpdColmn);
string _sqlCompany = " Delete from UsrCompany1 Where ZT_Id=@ZT_Id and Usr_Id=@Usr_Id ;";
string _sqlRole = " ";
DataTable _dt = this.dataGridView1.DataSource as DataTable;
for (int i = 0; i < _dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(_dt.Rows[i]["Company_Id"].ToString()))
{
_sqlCompany += "If ((select 1 from UsrCompany1 where ZT_Id=@ZT_Id and Usr_Id=@Usr_Id and Company_Id='" + _dt.Rows[i]["Company_Id"].ToString() + "') is null) "
+ "Insert Into UsrCompany1(ZT_Id,Usr_Id,Company_Id,Role__Id,Usr__Id,Create__Date)"
+ "VALUES(@ZT_Id,@Usr_Id,'" + _dt.Rows[i]["Company_Id"].ToString() + "',@Role__Id,@Usr__Id,@Create__Date) ;";
}
if (!string.IsNullOrEmpty(_dt.Rows[i]["Company_Id"].ToString()) && !string.IsNullOrEmpty(_dt.Rows[i]["Role_Id"].ToString()))
{
_sqlRole = " Delete from UsrRole Where Company_Id='" + _dt.Rows[i]["Company_Id"].ToString() + "' and Usr_Id=@Usr_Id;";
_sqlRole += "If ((select 1 from UsrRole where Usr_Id=@Usr_Id and Company_Id='" + _dt.Rows[i]["Company_Id"].ToString() + "'"
+ "and Role_Id='" + _dt.Rows[i]["Role_Id"].ToString() + "') is null)"
+ "Insert Into UsrRole(Usr_Id,Company_Id,Role_Id,Role__Id,Usr__Id,Create__Date)"
+ "VALUES(@Usr_Id,'" + _dt.Rows[i]["Company_Id"].ToString() + "','"
+ _dt.Rows[i]["Role_Id"].ToString() + "',@Role__Id,@Usr__Id,@Create__Date) ; ";
}
}
SqlParameter[] paras = new SqlParameter[12];
paras[0] = new SqlParameter("@ZT_Id", SqlDbType.VarChar, 50);
paras[0].Value = "RMOTest";
paras[1] = new SqlParameter("@Usr_Id", SqlDbType.VarChar, 50);
paras[1].Value = this.txtUsrId.Text.Trim();
paras[2] = new SqlParameter("@Name", SqlDbType.VarChar, 100);
paras[2].Value = this.txtName.Text.Trim();
paras[3] = new SqlParameter("@Pwd", SqlDbType.VarChar, 100);
paras[3].Value = CommomHelper.GetMD5(this.txtPwd.Text.Trim());
paras[4] = new SqlParameter("@B_Date", SqlDbType.DateTime);
paras[4].Value = System.DateTime.Now;
paras[5] = new SqlParameter("@E_Date", SqlDbType.DateTime);
paras[5].Value = DBNull.Value;
paras[6] = new SqlParameter("@ZT_Admin_Id", SqlDbType.VarChar, 1);
paras[6].Value = "";
paras[7] = new SqlParameter("@Status_Id", SqlDbType.VarChar, 5);
paras[7].Value = "";
paras[8] = new SqlParameter("@Usr__Id", SqlDbType.VarChar, 50);
paras[8].Value = LoginInfo._Usr_id;
paras[9] = new SqlParameter("@Role__Id", SqlDbType.VarChar, 50);
paras[9].Value = ((LoginInfo._ZT_Admin_Id == "Z") ? "" : LoginInfo._Usr_Role);
paras[10] = new SqlParameter("@Create__Date", SqlDbType.DateTime);
paras[10].Value = System.DateTime.Now;
paras[11] = new SqlParameter("@Remark", SqlDbType.Text);
paras[11].Value = "";
if (SqlHelper.ExecuteQueryTrans(_sqlCompany + _sqlRole + _sqlStr, paras))
{
return(true);
}
else
{
return(false);
}
}
private void btnInput_Click(object sender, EventArgs e)
{
decimal _qty = CommomHelper.ToDecimal(this.txtQty.Text);
if (string.IsNullOrEmpty(this.txtQty.Text))
{
MessageBox.Show("数量必须输入！");
}
else
{
DataTable _dtnew = new DataTable();
BindingSource _bdSource = new BindingSource();
_bdSource = dataGridView1.DataSource as BindingSource;
if (_bdSource != null)
{
DataTable _dtBody = _bdSource.DataSource as DataTable;
if (_dtBody.Rows.Count > 0)
{
_dtnew = _dtBody.Copy();
}
else
{
_dtnew = _dtBody.Clone();
}
for (int i = 0; i < _qty; i++)
{
if (_dtnew == null)
{
return;
}
DataRow _dr = _dtnew.NewRow();
_dr["Company_Id"] = _Company_Id;
_dr["Shipping_Id"] = _Shipping_Id;
_dr["CsvPo_Id"] = _CsvPo_Id;
_dr["ItemPrpty_Id"] = _ItemPrpty_Id;
_dr["Itm_Full_Id"] = _itm_Full_Id;
if (Edit == "ADD")
{
_dr["Itm_Full_Id"] = System.Guid.NewGuid().ToString("N");
}
_dr["Scan_Ewm_Id"] = System.Guid.NewGuid().ToString("N");
_dr["ItemUnit_Id"] = _itemUt;
_dr["Qty"] = 1;
int _itm = 1;
if (_dtnew.Rows.Count > 0)
{
_itm = _dtnew.AsEnumerable().Select(t => t.Field <int>("Po_itm")).Max();
_itm += 1;
}
_dr["Itm"] = _itm;
_dr["Po_Itm"] = _itm;
_dr["Qty_Shipping"] = 1;
_dr["V"] = "V" + _itm;
_dr["Planning_Shipping_Date"] = System.DateTime.Now;
_dr["Shipping_Date"] = System.DateTime.Now;
_dr["Planning_Arrive_Date"] = System.DateTime.Now;
if (_dtnew.Select("Itm_Full_Id='" + _dr["Itm_Full_Id"].ToString() + "'").Length == 0)
{
_dtnew.Rows.Add(_dr);
}
else
{
MessageBox.Show("存在相同项！");// _dr["Itm_Full_Id"].ToString()
return;
}
}
}
BindingSource bindingSource1 = new BindingSource();
bindingSource1.DataSource = _dtnew;
this.dataGridView1.DataSource = bindingSource1;
}
}
