/// <summary>
/// 插入
/// </summary>
/// <param name="PWtable"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool insertPWarehouseTable_titleBll(PWarehouseTable_title PWtable, string SQLCommand)
{
if (pwd.insertPWarehouseTable_titleDal(PWtable, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
PWarehouseTable_title GetPWarehouseTable_title(string Fid)
{
PWarehouseTable_title pwtable = new PWarehouseTable_title()
{
ID = Guid.NewGuid().ToString(),
WarehouseName = txt_Name.Text.Trim(),
FID = Fid
};
return(pwtable);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="PWtable"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertPWarehouseTable_titleDal(PWarehouseTable_title PWtable, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@ID", SqlDbType.VarChar, 80)
{
Value = PWtable.ID
},
new SqlParameter("@WarehouseName", SqlDbType.VarChar, 100)
{
Value = PWtable.WarehouseName
},
new SqlParameter("@FID", SqlDbType.VarChar, 80)
{
Value = PWtable.FID
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
