/// <summary>
/// 将表格内的数据传入页面
/// </summary>
private void choosegoods()
{
ZcGoodsMaster zcGoodsMaster = new ZcGoodsMaster();
zcGoodsMaster.SerialNumber = goodsDataGridView.SelectedRows[0].Cells[0].Value.ToString();
zcGoodsMaster.GoodsName = goodsDataGridView.SelectedRows[0].Cells[1].Value.ToString();
zcGoodsMaster.GoodsUnit = goodsDataGridView.SelectedRows[0].Cells[2].Value.ToString();
zcGoodsMaster.GoodsSpecifications = goodsDataGridView.SelectedRows[0].Cells[3].Value.ToString();
zcGoodsMaster.GoodsPrice = float.Parse(goodsDataGridView.SelectedRows[0].Cells[4].Value.ToString());
zcGoodsMaster.Remark = goodsDataGridView.SelectedRows[0].Cells[5].Value.ToString();
zcGoodsMaster.Id = goodsDataGridView.SelectedRows[0].Cells[6].Value.ToString();
if (this.count.Equals(ParentWindow.DeliveryGoods.ToString()))
{
this.deliveryGoods.AddGoods(zcGoodsMaster, num);
}
else if (this.count.Equals(ParentWindow.ReturnGoods.ToString()))
{
this.returnGoods.AddGoods(zcGoodsMaster, num);
}
else if (this.count.Equals(ParentWindow.CustomerDelivery.ToString()))
{
this.customerDelivery.AddGoods(zcGoodsMaster, num);
}
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="obj"></param>
public void AddGoods(ZcGoodsMaster obj)
{
//DataSet ds = (DataSet)itemDataGridView.DataSource;
//MessageBox.Show("货号为" + obj.SerialNumber + "的" + obj.GoodsName);
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// if (ds.Tables[0].Rows[i][0].ToString().Equals(obj.SerialNumber))
// {
// MessageBox.Show("货号为" + obj.SerialNumber + "的" + obj.GoodsName + "已经在第" + (i + 1) + "行，请不要重复添加!");
// return;
// }
//}
//ds.Tables[0].Rows.Add(obj.SerialNumber, obj.GoodsName, obj.GoodsUnit, obj.GoodsSpecifications, 0, obj.GoodsPrice, 0.00, obj.Remark, Guid.NewGuid().ToString(), obj.Id);
}
/// <summary>
/// 添加商品
/// </summary>a
/// <param name="obj"></param>
/// <param name="num">商品份数</param>
public void AddGoods(ZcGoodsMaster obj, string num)
{
//DataSet ds = (DataSet)itemDataGridView.DataSource;
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// if (ds.Tables[0].Rows[i][0].ToString().ToString().Equals(obj.SerialNumber))
// {
// string nums = itemDataGridView[5, i].Value.ToString();
// itemDataGridView[5, i].Value = Convert.ToInt32(nums) + Convert.ToInt32(num);
// return;
// }
//}
//ds.Tables[0].Rows.Add(obj.SerialNumber, obj.GoodsName, obj.GoodsUnit, obj.GoodsSpecifications, num, obj.GoodsPrice, (Convert.ToInt32(num) * obj.GoodsPrice).ToString("0.00"), obj.Remark, Guid.NewGuid().ToString(), obj.Id);
////Calculate();
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="obj"></param>
/// <param name="num">商品份数</param>
public void AddGoods(ZcGoodsMaster obj, string num)
{
DataSet ds = (DataSet)itemDataGridView.DataSource;
bool flag = false;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i][0].ToString().Equals(obj.SerialNumber))
{
string nums = itemDataGridView[4, i].Value.ToString();
itemDataGridView[4, i].Value = Convert.ToInt32(nums) + Convert.ToInt32(num);
return;
}
else
{
}
if (itemDataGridView[0, i].Value.ToString().Equals(obj.SerialNumber)) //
{ //
row = i; //
column = 5; //
//itemsInput.sureflag = true;//
flag = true; //
this.itemDataGridView.CurrentCell = itemDataGridView[4, row]; //单元格设置可编辑状态-
itemDataGridView.BeginEdit(true);
}//
}
if (!flag)
{
MessageBox.Show("今天收货订单中没有此商品，请与总部联系");
return;
}
//自动计算
Calculate();
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// if (ds.Tables[0].Rows[i][0].ToString().ToString().Equals(obj.SerialNumber))
// {
// string nums = itemDataGridView[5, i].Value.ToString();
// itemDataGridView[5, i].Value = Convert.ToInt32(nums) + Convert.ToInt32(num);
// return;
// }
//}
//ds.Tables[0].Rows.Add(obj.SerialNumber, obj.GoodsName, obj.GoodsUnit, obj.GoodsSpecifications, num, obj.GoodsPrice, (Convert.ToInt32(num) * obj.GoodsPrice).ToString("0.00"), obj.Remark, Guid.NewGuid().ToString(), obj.Id);
//Calculate();
}
public List <ZcGoodsMaster> FindAll()
{
List <ZcGoodsMaster> list = new List <ZcGoodsMaster>();
OracleConnection conn = null;
try
{
conn = OracleUtil.OpenConn();
string sql = "select ID,CREATETIME,UPDATETIME, DELFLAG, DISTRIBUTION_PRICE, EARLY_WARNING_DAYS, EARLY_WARNING_DAYS2, "
+ " GOODSATTRIBUTE, GOODS_DISCOUNT_RATE, GOODS_PY_CODE, GOODS_CODE, GOODS_NAME, GOODS_ORIGIN, GOODS_PRICE, "
+ " GOODS_PROPERTY, GOODS_PURCHASE_PRICE, GOODS_SPECIFICATIONS, GOODS_STATE, GOODS_TYPE, GOODS_UNIT, GROSS_MARGIN, "
+ " INPUT_TAX, JOINT_RATE, LOWEST_PRICE, MANAGEMENT_INVENTORY, MEMBER_PRICE, MEMBER_PRICE2, MEMBER_PRICE3, MEMBER_PRICE4, MEMBER_PRICE5, "
+ " OUT_TAX, POINT_OR_NOT, POINTS_VALUE, PROCUREMENT_STATUS, PRODUCTGOODSID, PURCHASE_SPECIFICATIONS, REMARK, SERIALNUMBER, STORE, VALIDITY_PERIOD, "
+ " VALUATION_METHOD, WASTERATE, WHOLESALE_PRICE, WHOLESALE_PRICE2, WHOLESALE_PRICE3, WHOLESALE_PRICE4,WHOLESALE_PRICE5,WHOLESALE_PRICE6,WHOLESALE_PRICE7,WHOLESALE_PRICE8, "
+ " ZCUSERINFO, GOODSFILE_USERID, GOODSTYPE_ID, GOODS_BRAND_ID, GOODS_CLASS_ID, GOODS_SUPPLIER_ID from zc_goods_master";
OracleCommand command = new OracleCommand(sql);
command.Connection = conn;
var reader = command.ExecuteReader();
while (reader.Read())
{
ZcGoodsMaster obj = new ZcGoodsMaster();
obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
obj.DelFlag = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
obj.DistributionPrice = reader.IsDBNull(4) ? default(float) : reader.GetFloat(4);
obj.EarlyWarningDays = reader.IsDBNull(5) ? default(float) : reader.GetFloat(5);
obj.EarlyWarningDays2 = reader.IsDBNull(6) ? default(float) : reader.GetFloat(6);
obj.GoodsAttribute = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
obj.GoodsDiscountRate = reader.IsDBNull(8) ? default(float) : reader.GetFloat(8);
obj.GoodsPyCode = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
obj.GoodsCode = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
obj.GoodsName = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
obj.GoodsOrigin = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
obj.GoodsPrice = reader.IsDBNull(13) ? default(float) : reader.GetFloat(13);
obj.GoodsProperty = reader.IsDBNull(14) ? string.Empty : reader.GetString(14);
obj.GoodsPurchasePrice = reader.IsDBNull(15) ? string.Empty : reader.GetFloat(15).ToString();
obj.GoodsSpecifications = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
obj.GoodsState = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
obj.GoodsType = reader.IsDBNull(18) ? string.Empty : reader.GetString(18);
obj.GoodsUnit = reader.IsDBNull(19) ? string.Empty : reader.GetString(19);
obj.GrossMargin = reader.IsDBNull(20) ? default(float) : reader.GetFloat(20);
obj.InputTax = reader.IsDBNull(21) ? default(float) : reader.GetFloat(21);
obj.JoinRate = reader.IsDBNull(22) ? default(float) : reader.GetFloat(22);
obj.LowestPrice = reader.IsDBNull(23) ? default(float) : reader.GetFloat(23);
obj.ManagementInventory = reader.IsDBNull(24) ? string.Empty : reader.GetString(24);
obj.MemberPrice = reader.IsDBNull(25) ? default(float) : reader.GetFloat(25);
obj.MemberPrice2 = reader.IsDBNull(26) ? default(float) : reader.GetFloat(26);
obj.MemberPrice3 = reader.IsDBNull(27) ? default(float) : reader.GetFloat(27);
obj.MemberPrice4 = reader.IsDBNull(28) ? default(float) : reader.GetFloat(28);
obj.MemberPrice5 = reader.IsDBNull(29) ? default(float) : reader.GetFloat(29);
obj.OutTax = reader.IsDBNull(30) ? default(float) : reader.GetFloat(30);
obj.PointOrNot = reader.IsDBNull(31) ? string.Empty : reader.GetString(31);
obj.PointsValue = reader.IsDBNull(32) ? default(float) : reader.GetFloat(32);
obj.ProcurementStatus = reader.IsDBNull(33) ? string.Empty : reader.GetString(33);
obj.ProductGoodsId = reader.IsDBNull(34) ? string.Empty : reader.GetString(34);
obj.PurchaseSpecifications = reader.IsDBNull(35) ? string.Empty : reader.GetString(35);
obj.Remark = reader.IsDBNull(36) ? string.Empty : reader.GetString(36);
obj.SerialNumber = reader.IsDBNull(37) ? string.Empty : reader.GetString(37);
obj.Store = reader.IsDBNull(38) ? string.Empty : reader.GetString(38);
obj.ValidityPeriod = reader.IsDBNull(39) ? default(float) : reader.GetFloat(39);
obj.ValucationMethod = reader.IsDBNull(40) ? string.Empty : reader.GetString(40);
obj.WasteRate = reader.IsDBNull(41) ? string.Empty : reader.GetString(41);
obj.WholeSalePrice = reader.IsDBNull(42) ? default(float) : reader.GetFloat(42);
obj.WholeSalePrice2 = reader.IsDBNull(43) ? default(float) : reader.GetFloat(43);
obj.WholeSalePrice3 = reader.IsDBNull(44) ? default(float) : reader.GetFloat(44);
obj.WholeSalePrice4 = reader.IsDBNull(45) ? default(float) : reader.GetFloat(45);
obj.WholeSalePrice5 = reader.IsDBNull(46) ? default(float) : reader.GetFloat(46);
obj.WholeSalePrice6 = reader.IsDBNull(47) ? default(float) : reader.GetFloat(47);
obj.WholeSalePrice7 = reader.IsDBNull(48) ? default(float) : reader.GetFloat(48);
obj.WholeSalePrice8 = reader.IsDBNull(49) ? default(float) : reader.GetFloat(49);
obj.ZcUserInfoId = reader.IsDBNull(50) ? string.Empty : reader.GetString(50);
obj.GoodsFileUserId = reader.IsDBNull(51) ? string.Empty : reader.GetString(51);
obj.GoodsTypeId = reader.IsDBNull(52) ? string.Empty : reader.GetString(52);
obj.GoodsBrandId = reader.IsDBNull(53) ? string.Empty : reader.GetString(53);
obj.GoodsClassId = reader.IsDBNull(54) ? string.Empty : reader.GetString(54);
obj.GoodsSupplierId = reader.IsDBNull(55) ? string.Empty : reader.GetString(55);
list.Add(obj);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
OracleUtil.CloseConn(conn);
}
return(list);
}
/// <summary>
/// 查询条码匹配的记录
/// </summary>
/// <param name="bar">条码</param>
/// <returns>商品匹配的记录数</returns>
public int queryExistGood(ILog log)
{
int con = 0;
ZcGoodsMaster zcGoodsMaster = new ZcGoodsMaster();
MysqlDBHelper dbHelper = new MysqlDBHelper();
MySqlConnection conn = dbHelper.GetConnection();
try
{
string sql = "select a.SERIALNUMBER ,a.goods_name,a.goods_unit,a.goods_specifications,a.goods_price,a.remark,a.id from zc_goods_master a "
+ "left join zc_classify_info b on a.goods_class_id = b.id "
+ "left join zc_classify_info c on a.goods_brand_id = c.id "
+ "left join zc_provider_info d on a.goods_supplier_id = d.id where 1=1 ";
if (this.count.Equals(ParentWindow.CustomerDelivery.ToString()) || this.count.Equals(ParentWindow.DeliveryGoods.ToString()))
{
sql += " and a.SERIALNUMBER like '%" + bar + "%'";
}
else
{
sql += " and a.SERIALNUMBER like '%" + bar + "%' or a.goods_name like '%" + bar + "%' or a.goods_unit like '%" + bar + "%' or a.goods_specifications like '%" + bar + "%' or a.goods_price like '%" + bar + "%' or a.remark like '%" + bar + "%' ;";
}
MySqlDataReader reader = dbHelper.GetReader(sql, conn);
while (reader.Read())
{
con += 1;
if (con == 1)
{
zcGoodsMaster.SerialNumber = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
zcGoodsMaster.GoodsName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
zcGoodsMaster.GoodsUnit = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
zcGoodsMaster.GoodsSpecifications = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
zcGoodsMaster.GoodsPrice = reader.IsDBNull(4) ? default(float) : reader.GetFloat(4);
zcGoodsMaster.Remark = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
zcGoodsMaster.Id = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
}
}
if (con == 1)
{
if (num.Equals(""))
{
num = "1";
}
if (this.count.Equals(ParentWindow.DeliveryGoods.ToString()))
{
this.deliveryGoods.AddGoods(zcGoodsMaster, num);
}
else if (this.count.Equals(ParentWindow.ReturnGoods.ToString()))
{
this.returnGoods.AddGoods(zcGoodsMaster, num);
}
else if (this.count.Equals(ParentWindow.CustomerDelivery.ToString()))
{
this.customerDelivery.AddGoods(zcGoodsMaster, num);
}
}
}
catch (Exception ex)
{
log.Error("选择扫描商品绑定数据发生异常", ex);
}
finally
{
dbHelper.CloseConnection(conn);
}
return(con);
}
