public FishEntity.PaymentRequisitionDetailEntity getModelDeta(DataRow row)
{
FishEntity.PaymentRequisitionDetailEntity model = new FishEntity.PaymentRequisitionDetailEntity( );
if (row != null)
{
if (row ["code"] != null)
{
model.code = row ["code"].ToString( );
}
if (row ["codeNumContract"] != null)
{
model.codeNumContract = row ["codeNumContract"].ToString( );
}
//if ( row [ "moneyOfBZJ" ] != null && row [ "moneyOfBZJ" ] . ToString ( ) != "" )
//{
// model . moneyOfBZJ = decimal . Parse ( row [ "moneyOfBZJ" ] . ToString ( ) );
//}
if (row ["moneyOfYFK"] != null && row ["moneyOfYFK"].ToString( ) != "")
{
model.moneyOfYFK = decimal.Parse(row ["moneyOfYFK"].ToString( ));
}
if (row ["saleUnit"] != null)
{
model.SaleUnit = row ["saleUnit"].ToString( );
}
if (row ["saleUser"] != null)
{
model.SaleUser = row ["saleUser"].ToString( );
}
if (row ["fishId"] != null)
{
model.FishId = row ["fishId"].ToString( );
}
if (row ["purchaseUnitId"] != null)
{
model.PurchaseUnitId = row ["purchaseUnitId"].ToString( );
}
if (row ["saleUnitId"] != null)
{
model.SaleUnitId = row ["saleUnitId"].ToString( );
}
if (row ["saleUserId"] != null)
{
model.SaleUserId = row ["saleUserId"].ToString( );
}
if (row ["openBanK"] != null)
{
model.OpenBanK = row ["openBanK"].ToString( );
}
if (row ["accountNumber"] != null)
{
model.AccountNumber = row ["accountNumber"].ToString( );
}
}
return(model);
}
void edit(Hashtable SQLString, StringBuilder strSql, FishEntity.PaymentRequisitionDetailEntity model)
{
strSql = new StringBuilder( );
strSql.Append("update t_paymentrequisitiondetail set ");
strSql.Append("moneyOfYFK=@moneyOfYFK,");
strSql.Append("saleUnit=@saleUnit,");
strSql.Append("saleUser=@saleUser,");
strSql.Append("fishId=@fishId,");
strSql.Append("purchaseUnit=@purchaseUnit,");
strSql.Append("purchaseUnitId=@purchaseUnitId,");
strSql.Append("saleUnitId=@saleUnitId,");
strSql.Append("saleUserId=@saleUserId,");
strSql.Append("openBanK=@openBanK,");
strSql.Append("accountNumber=@accountNumber,");
strSql.Append("modifyman=@modifyman,");
strSql.Append("modifytime=@modifytime ");
strSql.Append("where code=@code and ");
strSql.Append("CNumbering=@CNumbering and ");
strSql.Append("codeNumContract=@codeNumContract");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@CNumbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45),
new MySqlParameter("@moneyOfYFK", MySqlDbType.Decimal, 11),
new MySqlParameter("@saleUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUser", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45),
new MySqlParameter("@modifytime", MySqlDbType.Timestamp),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUnitId", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUnitId", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUserId", MySqlDbType.VarChar, 45),
new MySqlParameter("@openBanK", MySqlDbType.VarChar, 45),
new MySqlParameter("@accountNumber", MySqlDbType.VarChar, 45)
};
parameters [0].Value = model.code;
parameters [1].Value = model.codeNum;
parameters [2].Value = model.codeNumContract;
parameters [4].Value = model.moneyOfYFK;
parameters [5].Value = model.SaleUnit;
parameters [6].Value = model.SaleUser;
parameters [7].Value = model.modifyman;
parameters [8].Value = model.modifytime;
parameters [9].Value = model.FishId;
parameters [10].Value = model.PurchaseUnit;
parameters [11].Value = model.PurchaseUnitId;
parameters [12].Value = model.SaleUnitId;
parameters [13].Value = model.SaleUserId;
parameters [14].Value = model.OpenBanK;
parameters [15].Value = model.AccountNumber;
SQLString.Add(strSql, parameters);
}
void add(Hashtable SQLString, StringBuilder strSql, FishEntity.PaymentRequisitionDetailEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO t_paymentrequisitiondetail (");
strSql.Append("code,CNumbering,codeNumContract,moneyOfYFK,saleUnit,saleUser,createman,createtime,fishId,purchaseUnit,purchaseUnitId,saleUnitId,saleUserId,openBanK,accountNumber)");
strSql.Append("values (");
strSql.Append("@code,@CNumbering,@codeNumContract,@moneyOfYFK,@saleUnit,@saleUser,@createman,@createtime,@fishId,@purchaseUnit,@purchaseUnitId,@saleUnitId,@saleUserId,@openBanK,@accountNumber) ");
MySqlParameter [] parameters =
{
new MySqlParameter("@code", MySqlDbType.VarChar, 45),
new MySqlParameter("@CNumbering", MySqlDbType.VarChar, 45),
new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 45),
new MySqlParameter("@moneyOfYFK", MySqlDbType.Decimal, 11),
new MySqlParameter("@saleUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUser", MySqlDbType.VarChar, 45),
new MySqlParameter("@createman", MySqlDbType.VarChar, 45),
new MySqlParameter("@createtime", MySqlDbType.Timestamp),
new MySqlParameter("@fishId", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUnit", MySqlDbType.VarChar, 45),
new MySqlParameter("@purchaseUnitId", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUnitId", MySqlDbType.VarChar, 45),
new MySqlParameter("@saleUserId", MySqlDbType.VarChar, 45),
new MySqlParameter("@openBanK", MySqlDbType.VarChar, 45),
new MySqlParameter("@accountNumber", MySqlDbType.VarChar, 45)
};
parameters [0].Value = model.code;
parameters [1].Value = model.codeNum;
parameters [2].Value = model.codeNumContract;
parameters [3].Value = model.moneyOfYFK;
parameters [4].Value = model.SaleUnit;
parameters [5].Value = model.SaleUser;
parameters [6].Value = model.createman;
parameters [7].Value = model.createtime;
parameters [8].Value = model.FishId;
parameters [9].Value = model.PurchaseUnit;
parameters [10].Value = model.PurchaseUnitId;
parameters [11].Value = model.SaleUnitId;
parameters [12].Value = model.SaleUserId;
parameters [13].Value = model.OpenBanK;
parameters [14].Value = model.AccountNumber;
SQLString.Add(strSql, parameters);
}
void delete(Hashtable SQLString, StringBuilder strSql, FishEntity.PaymentRequisitionDetailEntity model)
{
strSql = new StringBuilder( );
strSql.AppendFormat("delete from t_paymentrequisitiondetail where code='{0}' and CNumbering='{1}' and codeNumContract='{2}'", model.code, model.codeNum, model.codeNumContract);
SQLString.Add(strSql, null);
}
