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));
}
