public FishEntity.AccountsReceivableHead getModel(DataRow row)
{
FishEntity.AccountsReceivableHead _head = new FishEntity.AccountsReceivableHead( );
if (row != null)
{
if (row ["yfId"] != null)
{
_head.yfId = row ["yfId"].ToString( );
}
if (row ["province"] != null)
{
_head.province = row ["province"].ToString( );
}
if (row ["region"] != null)
{
_head.region = row ["region"].ToString( );
}
if (row ["customer"] != null)
{
_head.customer = row ["customer"].ToString( );
}
if (row ["salesman"] != null)
{
_head.salesman = row ["salesman"].ToString( );
}
if (row ["yearArrears"] != null && row ["yearArrears"].ToString( ) != "")
{
_head.yearArrears = decimal.Parse(row ["yearArrears"].ToString( ));
}
if (row ["monthReceivable"] != null && row ["monthReceivable"].ToString( ) != "")
{
_head.monthReceivable = decimal.Parse(row ["monthReceivable"].ToString( ));
}
if (row ["monthNetreceipts"] != null && row ["monthNetreceipts"].ToString( ) != "")
{
_head.monthNetreceipts = decimal.Parse(row ["monthNetreceipts"].ToString( ));
}
if (row ["yearReceivable"] != null && row ["yearReceivable"].ToString( ) != "")
{
_head.YearReceivable = decimal.Parse(row ["yearReceivable"].ToString( ));
}
if (row ["yearNetreceipts"] != null && row ["yearNetreceipts"].ToString( ) != "")
{
_head.yearNetreceipts = decimal.Parse(row ["yearNetreceipts"].ToString( ));
}
if (row ["remark"] != null)
{
_head.remark = row ["remark"].ToString( );
}
if (row ["count"] != null && row ["count"].ToString( ) != "")
{
_head.count = int.Parse(row ["count"].ToString( ));
}
}
return(_head);
}
void edit(FishEntity.AccountsReceivableHead _head, Hashtable SQLString, StringBuilder strSql)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE t_AccountsReceivableHead SET ");
strSql.Append("province=@province,");
strSql.Append("region=@region,");
strSql.Append("customer=@customer,");
strSql.Append("salesman=@salesman,");
strSql.Append("yearArrears=@yearArrears,");
strSql.Append("monthReceivable=@monthReceivable,");
strSql.Append("monthNetreceipts=@monthNetreceipts,");
strSql.Append("yearReceivable=@yearReceivable,");
strSql.Append("yearNetreceipts=@yearNetreceipts,");
strSql.Append("remark=@remark,");
strSql.Append("count=@count,");
strSql.Append("modifyTime=@modifyTime,");
strSql.Append("modifyMan=@modifyMan ");
strSql.Append("where yfId=@yfId");
MySqlParameter [] parameter =
{
new MySqlParameter("@yfId", MySqlDbType.VarChar, 45),
new MySqlParameter("@province", MySqlDbType.VarChar, 45),
new MySqlParameter("@region", MySqlDbType.VarChar, 45),
new MySqlParameter("@customer", MySqlDbType.VarChar, 45),
new MySqlParameter("@salesman", MySqlDbType.VarChar, 45),
new MySqlParameter("@yearArrears", MySqlDbType.Decimal, 45),
new MySqlParameter("@monthReceivable", MySqlDbType.Decimal, 45),
new MySqlParameter("@monthNetreceipts", MySqlDbType.Decimal, 45),
new MySqlParameter("@yearReceivable", MySqlDbType.Decimal, 45),
new MySqlParameter("@yearNetreceipts", MySqlDbType.Decimal, 45),
new MySqlParameter("@remark", MySqlDbType.VarChar, 45),
new MySqlParameter("@count", MySqlDbType.Int32),
new MySqlParameter("@modifyTime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyMan", MySqlDbType.VarChar, 45)
};
parameter [0].Value = _head.yfId;
parameter [1].Value = _head.province;
parameter [2].Value = _head.region;
parameter [3].Value = _head.customer;
parameter [4].Value = _head.salesman;
parameter [5].Value = _head.yearArrears;
parameter [6].Value = _head.monthReceivable;
parameter [7].Value = _head.monthNetreceipts;
parameter [8].Value = _head.YearReceivable;
parameter [9].Value = _head.yearNetreceipts;
parameter [10].Value = _head.remark;
parameter [11].Value = _head.count;
parameter [12].Value = _head.modifyTime;
parameter [13].Value = _head.modifyMan;
SQLString.Add(strSql, parameter);
}
void add(FishEntity.AccountsReceivableHead _head, Hashtable SQLString, StringBuilder strSql)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO t_AccountsReceivableHead (");
strSql.Append("yfId,province,region,customer,salesman,yearArrears,monthReceivable,monthNetreceipts,yearReceivable,yearNetreceipts,remark,count,createTime,createMan,modifyTime,modifyMan) ");
strSql.Append("VALUES (");
strSql.Append("@yfId,@province,@region,@customer,@salesman,@yearArrears,@monthReceivable,@monthNetreceipts,@yearReceivable,@yearNetreceipts,@remark,@count,@createTime,@createMan,@modifyTime,@modifyMan)");
MySqlParameter [] parameter =
{
new MySqlParameter("@yfId", MySqlDbType.VarChar, 45),
new MySqlParameter("@province", MySqlDbType.VarChar, 45),
new MySqlParameter("@region", MySqlDbType.VarChar, 45),
new MySqlParameter("@customer", MySqlDbType.VarChar, 45),
new MySqlParameter("@salesman", MySqlDbType.VarChar, 45),
new MySqlParameter("@yearArrears", MySqlDbType.Decimal, 45),
new MySqlParameter("@monthReceivable", MySqlDbType.Decimal, 45),
new MySqlParameter("@monthNetreceipts", MySqlDbType.Decimal, 45),
new MySqlParameter("@yearReceivable", MySqlDbType.Decimal, 45),
new MySqlParameter("@yearNetreceipts", MySqlDbType.Decimal, 45),
new MySqlParameter("@remark", MySqlDbType.VarChar, 45),
new MySqlParameter("@count", MySqlDbType.Int32),
new MySqlParameter("@createTime", MySqlDbType.Timestamp),
new MySqlParameter("@createMan", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifyTime", MySqlDbType.Timestamp),
new MySqlParameter("@modifyMan", MySqlDbType.VarChar, 45)
};
parameter [0].Value = _head.yfId;
parameter [1].Value = _head.province;
parameter [2].Value = _head.region;
parameter [3].Value = _head.customer;
parameter [4].Value = _head.salesman;
parameter [5].Value = _head.yearArrears;
parameter [6].Value = _head.monthReceivable;
parameter [7].Value = _head.monthNetreceipts;
parameter [8].Value = _head.YearReceivable;
parameter [9].Value = _head.yearNetreceipts;
parameter [10].Value = _head.remark;
parameter [11].Value = _head.count;
parameter [12].Value = _head.createTime;
parameter [13].Value = _head.createMan;
parameter [14].Value = _head.modifyTime;
parameter [15].Value = _head.modifyMan;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 编辑单头记录
/// </summary>
/// <param name="yfId"></param>
/// <param name="userName"></param>
/// <returns></returns>
public bool head_one(string yfId, string userName)
{
Hashtable SQLString = new Hashtable( );
DataTable da = GetDataTableCode(yfId);
if (da == null || da.Rows.Count < 1)
{
return(false);
}
FishEntity.AccountsReceivableHead _head = new FishEntity.AccountsReceivableHead( );
_head.yfId = yfId;
_head.province = da.Rows [0] ["province"].ToString( );
_head.region = da.Rows [0] ["zone"].ToString( );
_head.customer = da.Rows [0] ["fullname"].ToString( );
_head.salesman = da.Rows [0] ["salesman"].ToString( );
da = null;
da = GetDataTableAmountOne(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.yearArrears = string.IsNullOrEmpty(da.Rows [0] ["rmb"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["rmb"].ToString( ));
}
else
{
_head.yearArrears = 0;
}
da = null;
da = GetDataTableAmountTwo(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.monthReceivable = string.IsNullOrEmpty(da.Rows [0] ["rmb"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["rmb"].ToString( ));
}
else
{
_head.monthReceivable = 0;
}
da = null;
da = GetDataTableAmountTre(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.monthNetreceipts = string.IsNullOrEmpty(da.Rows [0] ["rmb"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["rmb"].ToString( ));
}
else
{
_head.monthNetreceipts = 0;
}
da = null;
da = GetDataTableAmountFor(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.YearReceivable = string.IsNullOrEmpty(da.Rows [0] ["rmb"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["rmb"].ToString( ));
}
else
{
_head.YearReceivable = 0;
}
da = null;
da = GetDataTableAmountFiv(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.yearNetreceipts = string.IsNullOrEmpty(da.Rows [0] ["rmb"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["rmb"].ToString( ));
}
else
{
_head.yearNetreceipts = 0;
}
da = null;
da = count(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.count = string.IsNullOrEmpty(da.Rows [0] ["coun"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["coun"].ToString( ));
}
else
{
_head.count = 0;
}
da = null;
da = remark(yfId);
if (da != null && da.Rows.Count > 0)
{
_head.remark = da.Rows [0] ["remark"].ToString( );
}
else
{
_head.remark = string.Empty;
}
_head.createTime = _head.modifyTime = getTime( );
_head.createMan = _head.modifyMan = userName;
StringBuilder strSql = new StringBuilder( );
if (Exist(yfId) == true)
{
edit(_head, SQLString, strSql);
}
else
{
add(_head, SQLString, strSql);
}
return(MySqlHelper.ExecuteSqlTran(SQLString));
}
