void add(FishEntity.AccountsreceivableBody _body, Hashtable SQLString, StringBuilder strSql) { strSql = new StringBuilder( ); strSql.Append("INSERT INTO t_AccountsReceivableBody ("); strSql.Append("date,num,price,paymentDate,quality,customer,salesman,deliveryDay,deliveryMonth,deliveryNum,receivablesDay,receivablesMonth,receivablesAmount,receuvablesAcountNum,modifyTime,modifyMan,createTime,createMan,yfId,code)"); strSql.Append("VALUES ("); strSql.Append("@date,@num,@price,@paymentDate,@quality,@customer,@salesman,@deliveryDay,@deliveryMonth,@deliveryNum,@receivablesDay,@receivablesMonth,@receivablesAmount,@receuvablesAcountNum,@modifyTime,@modifyMan,@createTime,@createMan,@yfId,@code)"); MySqlParameter [] parameter = { new MySqlParameter("@yfId", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@num", MySqlDbType.Decimal, 45), new MySqlParameter("@price", MySqlDbType.Decimal, 45), new MySqlParameter("@paymentDate", MySqlDbType.Date), new MySqlParameter("@quality", MySqlDbType.VarChar, 45), new MySqlParameter("@customer", MySqlDbType.VarChar, 45), new MySqlParameter("@salesman", MySqlDbType.VarChar, 45), new MySqlParameter("@deliveryDay", MySqlDbType.Int32), new MySqlParameter("@deliveryMonth", MySqlDbType.Int32), new MySqlParameter("@deliveryNum", MySqlDbType.Decimal, 45), new MySqlParameter("@receivablesDay", MySqlDbType.Int32), new MySqlParameter("@receivablesMonth", MySqlDbType.Int32), new MySqlParameter("@receivablesAmount", MySqlDbType.Decimal, 45), new MySqlParameter("@receuvablesAcountNum", MySqlDbType.VarChar, 45), new MySqlParameter("@modifyTime", MySqlDbType.Timestamp), new MySqlParameter("@modifyMan", MySqlDbType.VarChar, 45), new MySqlParameter("@createTime", MySqlDbType.Timestamp), new MySqlParameter("@createMan", MySqlDbType.VarChar, 45) }; parameter [0].Value = _body.yfId; parameter [1].Value = _body.code; parameter [2].Value = _body.date; parameter [3].Value = _body.num; parameter [4].Value = _body.price; parameter [5].Value = _body.paymentDate; parameter [6].Value = _body.quality; parameter [7].Value = _body.customer; parameter [8].Value = _body.salesman; parameter [9].Value = _body.deliveryDay; parameter [10].Value = _body.deliveryMonth; parameter [11].Value = _body.deliveryNum; parameter [12].Value = _body.receivablesDay; parameter [13].Value = _body.receivablesMonth; parameter [14].Value = _body.receivablesAmount; parameter [15].Value = _body.receuvablesAcountNum; parameter [16].Value = _body.modifyTime; parameter [17].Value = _body.modifyMan; parameter [18].Value = _body.createTime; parameter [19].Value = _body.createMan; SQLString.Add(strSql, parameter); }
void adds(FishEntity.AccountsreceivableBody _body, Hashtable SQLString, StringBuilder strSql) { strSql = new StringBuilder( ); strSql.Append("UPDATE t_AccountsReceivableBody SET "); strSql.Append("settlementNum=@settlementNum,"); strSql.Append("modifyTime=@modifyTime,"); strSql.Append("modifyMan=@modifyMan "); strSql.Append("WHERE yfId=@yfId AND code=@code"); MySqlParameter [] parameter = { new MySqlParameter("@yfId", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@modifyTime", MySqlDbType.Timestamp), new MySqlParameter("@modifyMan", MySqlDbType.VarChar, 45), new MySqlParameter("@settlementNum", MySqlDbType.Decimal, 45) }; parameter [0].Value = _body.yfId; parameter [1].Value = _body.code; parameter [2].Value = _body.modifyTime; parameter [3].Value = _body.modifyMan; parameter [4].Value = _body.settlementNum; SQLString.Add(strSql, parameter); }
public FishEntity.AccountsreceivableBody getM(DataRow row) { FishEntity.AccountsreceivableBody _body = new FishEntity.AccountsreceivableBody( ); if (row != null) { if (row ["yfId"] != null) { _body.yfId = row ["yfId"].ToString( ); } if (row ["code"] != null) { _body.code = row ["code"].ToString( ); } if (row ["date"] != null && row ["date"].ToString( ) != "") { _body.date = DateTime.Parse(row ["date"].ToString( )); } if (row ["num"] != null && row ["num"].ToString( ) != "") { _body.num = decimal.Parse(row ["num"].ToString( )); } if (row ["price"] != null && row ["price"].ToString( ) != "") { _body.price = decimal.Parse(row ["price"].ToString( )); } if (row ["paymentDate"] != null && row ["paymentDate"].ToString( ) != "") { _body.paymentDate = DateTime.Parse(row ["paymentDate"].ToString( )); } if (row ["quality"] != null) { _body.quality = row ["quality"].ToString( ); } if (row ["customer"] != null) { _body.customer = row ["customer"].ToString( ); } if (row ["salesman"] != null) { _body.salesman = row ["salesman"].ToString( ); } if (row ["deliveryDay"] != null && row ["deliveryDay"].ToString( ) != "") { _body.deliveryDay = int.Parse(row ["deliveryDay"].ToString( )); } if (row ["deliveryMonth"] != null && row ["deliveryMonth"].ToString( ) != "") { _body.deliveryMonth = int.Parse(row ["deliveryMonth"].ToString( )); } if (row ["deliveryNum"] != null && row ["deliveryNum"].ToString( ) != "") { _body.deliveryNum = decimal.Parse(row ["deliveryNum"].ToString( )); } if (row ["settlementNum"] != null && row ["settlementNum"].ToString( ) != "") { _body.settlementNum = decimal.Parse(row ["settlementNum"].ToString( )); } if (row ["receivablesDay"] != null && row ["receivablesDay"].ToString( ) != "") { _body.receivablesDay = int.Parse(row ["receivablesDay"].ToString( )); } if (row ["receivablesMonth"] != null && row ["receivablesMonth"].ToString( ) != "") { _body.receivablesMonth = int.Parse(row ["receivablesMonth"].ToString( )); } if (row ["receivablesAmount"] != null && row ["receivablesAmount"].ToString( ) != "") { _body.receivablesAmount = decimal.Parse(row ["receivablesAmount"].ToString( )); } if (row ["receuvablesAcountNum"] != null) { _body.receuvablesAcountNum = row ["receuvablesAcountNum"].ToString( ); } if (row ["remark"] != null) { _body.remark = row ["remark"].ToString( ); } } return(_body); }
void edit(FishEntity.AccountsreceivableBody _body, Hashtable SQLString, StringBuilder strSql) { strSql = new StringBuilder( ); strSql.Append("UPDATE t_AccountsReceivableBody SET "); strSql.Append("date=@date,"); strSql.Append("num=@num,"); strSql.Append("price=@price,"); strSql.Append("paymentDate=@paymentDate,"); strSql.Append("quality=@quality,"); strSql.Append("customer=@customer,"); strSql.Append("salesman=@salesman,"); strSql.Append("deliveryDay=@deliveryDay,"); strSql.Append("deliveryMonth=@deliveryMonth,"); strSql.Append("deliveryNum=@deliveryNum,"); strSql.Append("receivablesDay=@receivablesDay,"); strSql.Append("receivablesMonth=@receivablesMonth,"); strSql.Append("receivablesAmount=@receivablesAmount,"); strSql.Append("receuvablesAcountNum=@receuvablesAcountNum,"); strSql.Append("modifyTime=@modifyTime,"); strSql.Append("modifyMan=@modifyMan "); strSql.Append("WHERE yfId=@yfId AND "); strSql.Append("code=@code"); MySqlParameter [] parameter = { new MySqlParameter("@yfId", MySqlDbType.VarChar, 45), new MySqlParameter("@code", MySqlDbType.VarChar, 45), new MySqlParameter("@date", MySqlDbType.Date), new MySqlParameter("@num", MySqlDbType.Decimal, 45), new MySqlParameter("@price", MySqlDbType.Decimal, 45), new MySqlParameter("@paymentDate", MySqlDbType.Date), new MySqlParameter("@quality", MySqlDbType.VarChar, 45), new MySqlParameter("@customer", MySqlDbType.VarChar, 45), new MySqlParameter("@salesman", MySqlDbType.VarChar, 45), new MySqlParameter("@deliveryDay", MySqlDbType.Int32), new MySqlParameter("@deliveryMonth", MySqlDbType.Int32), new MySqlParameter("@deliveryNum", MySqlDbType.Decimal, 45), new MySqlParameter("@receivablesDay", MySqlDbType.Int32), new MySqlParameter("@receivablesMonth", MySqlDbType.Int32), new MySqlParameter("@receivablesAmount", MySqlDbType.Decimal, 45), new MySqlParameter("@receuvablesAcountNum", MySqlDbType.VarChar, 45), new MySqlParameter("@modifyTime", MySqlDbType.Timestamp), new MySqlParameter("@modifyMan", MySqlDbType.VarChar, 45) }; parameter [0].Value = _body.yfId; parameter [1].Value = _body.code; parameter [2].Value = _body.date; parameter [3].Value = _body.num; parameter [4].Value = _body.price; parameter [5].Value = _body.paymentDate; parameter [6].Value = _body.quality; parameter [7].Value = _body.customer; parameter [8].Value = _body.salesman; parameter [9].Value = _body.deliveryDay; parameter [10].Value = _body.deliveryMonth; parameter [11].Value = _body.deliveryNum; parameter [12].Value = _body.receivablesDay; parameter [13].Value = _body.receivablesMonth; parameter [14].Value = _body.receivablesAmount; parameter [15].Value = _body.receuvablesAcountNum; parameter [16].Value = _body.modifyTime; parameter [17].Value = _body.modifyMan; SQLString.Add(strSql, parameter); }
/// <summary> /// 编辑单身记录 /// </summary> /// <param name="yfId"></param> /// <param name="yserName"></param> /// <returns></returns> public bool head_two(string yfId, string userName) { Hashtable SQLString = new Hashtable( ); StringBuilder strSql = new StringBuilder( ); DataTable da = new DataTable( ); da = GetDataTableBody(yfId); if (da != null && da.Rows.Count > 0) { FishEntity.AccountsreceivableBody _body = new FishEntity.AccountsreceivableBody( ); _body.yfId = yfId; _body.createTime = _body.modifyTime = getTime( ); _body.createMan = _body.modifyMan = userName; DataTable de = GetExists(yfId); for (int i = 0; i < da.Rows.Count; i++) { _body.code = da.Rows [i] ["code"].ToString( ); if (string.IsNullOrEmpty(da.Rows [i] ["Signdate"].ToString( ))) { _body.date = null; } else { _body.date = Convert.ToDateTime(da.Rows [i] ["Signdate"].ToString( )); } _body.num = string.IsNullOrEmpty(da.Rows [i] ["Quantity"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [i] ["Quantity"].ToString( )); _body.price = string.IsNullOrEmpty(da.Rows [i] ["unitprice"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [i] ["unitprice"].ToString( )); if (string.IsNullOrEmpty(da.Rows [i] ["payment"].ToString( ))) { _body.paymentDate = null; } else { _body.paymentDate = Convert.ToDateTime(da.Rows [i] ["payment"].ToString( )); } _body.quality = da.Rows [i] ["Variety"].ToString( ); _body.customer = da.Rows [i] ["demand"].ToString( ); _body.salesman = da.Rows [i] ["createman"].ToString( ); _body.deliveryDay = string.IsNullOrEmpty(da.Rows [i] ["dayOf"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["dayOf"].ToString( )); _body.deliveryMonth = string.IsNullOrEmpty(da.Rows [i] ["monthOf"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["monthOf"].ToString( )); _body.deliveryNum = string.IsNullOrEmpty(da.Rows [i] ["Competition"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [i] ["Competition"].ToString( )); _body.receivablesDay = string.IsNullOrEmpty(da.Rows [i] ["dayOfE"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["dayOfE"].ToString( )); _body.receivablesMonth = string.IsNullOrEmpty(da.Rows [i] ["monthOfE"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [i] ["monthOfE"].ToString( )); _body.receivablesAmount = string.IsNullOrEmpty(da.Rows [i] ["rmbE"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [i] ["rmbE"].ToString( )); _body.receuvablesAcountNum = da.Rows [i] ["fuKuanZhangHao"].ToString( ); if (de.Select("code='" + _body.code + "'").Length > 0) { edit(_body, SQLString, strSql); } else { add(_body, SQLString, strSql); } } DataTable dh = GetExists(yfId); if (dh != null && dh.Rows.Count > 0) { for (int i = 0; i < dh.Rows.Count; i++) { _body.code = dh.Rows [i] ["code"].ToString( ); if (da.Select("code='" + _body.code + "'").Length < 1) { delete(yfId, _body.code, SQLString, strSql); } } } } return(MySqlHelper.ExecuteSqlTran(SQLString)); }