public ActionResult Add()
{
Bse_File info = new Bse_File();
info.CF_Code = fInstance.GenerateComFileCode();
GetbackUrl();
return(View(info));
}
public bool UpdateModel(Bse_File model)
{
if (instance.Update(model) > 0)
{
return(true);
}
return(false);
}
public bool AddModel(Bse_File model)
{
if (instance.Add(model) > 0)
{
return(true);
}
return(false);
}
public bool DeleteModel(Bse_File model)
{
model.Stat = 1;
if (instance.Update(model) > 0)
{
return(true);
}
return(false);
}
public ActionResult Delete(string id)
{
Bse_File doc = fInstance.GetModel(string.Format("AND CF_Code='{0}'", id));
doc.Stat = 1;
fInstance.UpdateModel(doc);
BLL.Bll_Comm.OpLog("Bse_FileModule", "Delete", string.Format("删除文档:{0}", id));
return(Json(new { result = "success", message = "成功" }, "text/json"));
}
public List <Bse_File> GetListByWhereExtend(string strCondition)
{
List <Bse_File> ret = new List <Bse_File>();
string sql = @"select * from (SELECT CF_ID,CF_Code,CF_Name,CF_Path,CF_Cate,CF_CateName
,CF_Type,CF_iType,AuditStat
,AuditCurAudit,CF_Bak,f.Stat,da.DA_Allot,da.DA_Module,(select top 1 dict_name from bse_dict where dict_key='IsHandle' and dict_code=isnull(da.DA_IsHandle,'NoHandle')) as IsHandle
,f.CreateTime,f.UpdateTime,f.DeleteTime
FROM Bse_File f JOIN Doc_Allot da on f.CF_Code=da.DA_DocCode and isnull(da.stat,0)=0 and isnull(f.stat,0)=0
) aa WHERE 1=1 ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY CF_ID DESC ";
SqlDataReader dr = null;
try
{
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_File bse_File = new Bse_File();
if (dr["CF_ID"] != DBNull.Value)
{
bse_File.CF_ID = Convert.ToDecimal(dr["CF_ID"]);
}
if (dr["CF_Code"] != DBNull.Value)
{
bse_File.CF_Code = Convert.ToString(dr["CF_Code"]);
}
if (dr["CF_Name"] != DBNull.Value)
{
bse_File.CF_Name = Convert.ToString(dr["CF_Name"]);
}
if (dr["CF_Path"] != DBNull.Value)
{
bse_File.CF_Path = Convert.ToString(dr["CF_Path"]);
}
if (dr["CF_Cate"] != DBNull.Value)
{
bse_File.CF_Cate = Convert.ToString(dr["CF_Cate"]);
}
if (dr["CF_CateName"] != DBNull.Value)
{
bse_File.CF_CateName = Convert.ToString(dr["CF_CateName"]);
}
if (dr["CF_Type"] != DBNull.Value)
{
bse_File.CF_Type = Convert.ToString(dr["CF_Type"]);
}
if (dr["CF_iType"] != DBNull.Value)
{
bse_File.CF_iType = Convert.ToString(dr["CF_iType"]);
}
if (dr["AuditStat"] != DBNull.Value)
{
bse_File.AuditStat = Convert.ToString(dr["AuditStat"]);
}
if (dr["AuditCurAudit"] != DBNull.Value)
{
bse_File.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
}
if (dr["CF_Bak"] != DBNull.Value)
{
bse_File.CF_Bak = Convert.ToString(dr["CF_Bak"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_File.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
if (dr["IsHandle"] != DBNull.Value)
{
bse_File.IsHandle = Convert.ToString(dr["IsHandle"]);
}
ret.Add(bse_File);
}
}
catch (System.Exception ex) { throw ex; }
finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
public JsonResult FileOperation(FormCollection formCollect)
{
var flag = false;
Bse_File doc = new Bse_File();
bmHelper.BindFormToModel <Bse_File>(doc, formCollect);
string type = formCollect["optype"];
int isback = 0;
if (formCollect["formOper"] == "edit")
{
doc.UpdateTime = DateTime.Now;
if (type == "nor")
{
doc.CF_iType = "Draft";
}
else if (type == "submit")
{
doc.CF_iType = "Normal";
//进入审核流程
doc.AuditStat = "Auditing";
var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.ComFileAudit.ToString());
if (model != null)
{
doc.AuditCurAudit = model.VT_VerifyNode_Code;
}
}
flag = fInstance.UpdateModel(doc);
BLL.Bll_Comm.OpLog("Bse_FileModule", "FileOperation", string.Format("更新文件:{0}", doc.CF_Code));
}
else
{
isback = 1;
doc.CreateTime = DateTime.Now;
doc.UpdateTime = DateTime.Now;
if (type == "nor")
{
doc.CF_iType = "Draft";
}
else
{
doc.CF_iType = "Normal";
//进入审核流程
doc.AuditStat = "Auditing";
var model = auditInstance.GetVerifyTemplateFirstNode(AuditModuleEnum.DocumentAudit.ToString());
if (model != null)
{
doc.AuditCurAudit = model.VT_VerifyNode_Code;
}
}
doc.CF_Creator = SessionConfig.UserId();
doc.CF_CreatorName = SessionConfig.UserName();
flag = fInstance.AddModel(doc);
//日志记录
BLL.Bll_Comm.OpLog("Bse_FileModule", "FileOperation", string.Format("添加文件:{0}", doc.CF_Code));
}
if (flag)
{
return(Json(new { result = "success", isBack = isback, Msg = "数据更新成功！" }, "application/json"));
}
else
{
return(Json(new { result = "fail", Msg = "数据更新失败！" }, "application/json"));
}
}
/// <summary>
/// 获取所有的Bse_File对象(即:一条记录
/// </summary>
public List <Bse_File> GetAll()
{
List <Bse_File> ret = new List <Bse_File>();
string sql = "SELECT CF_ID,CF_Code,CF_Name,CF_Path,CF_Cate,CF_CateName,CF_Type,CF_TypeName,CF_iType,AuditStat,AuditCurAudit,CF_Bak,Stat,CreateTime,UpdateTime,DeleteTime,CF_Creator,CF_CreatorName FROM Bse_File where 1=1 AND ((Stat is null) or (Stat=0) ) order by CF_ID desc ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_File bse_File = new Bse_File();
if (dr["CF_ID"] != DBNull.Value)
{
bse_File.CF_ID = Convert.ToDecimal(dr["CF_ID"]);
}
if (dr["CF_Code"] != DBNull.Value)
{
bse_File.CF_Code = Convert.ToString(dr["CF_Code"]);
}
if (dr["CF_Name"] != DBNull.Value)
{
bse_File.CF_Name = Convert.ToString(dr["CF_Name"]);
}
if (dr["CF_Path"] != DBNull.Value)
{
bse_File.CF_Path = Convert.ToString(dr["CF_Path"]);
}
if (dr["CF_Cate"] != DBNull.Value)
{
bse_File.CF_Cate = Convert.ToString(dr["CF_Cate"]);
}
if (dr["CF_CateName"] != DBNull.Value)
{
bse_File.CF_CateName = Convert.ToString(dr["CF_CateName"]);
}
if (dr["CF_Type"] != DBNull.Value)
{
bse_File.CF_Type = Convert.ToString(dr["CF_Type"]);
}
if (dr["CF_TypeName"] != DBNull.Value)
{
bse_File.CF_TypeName = Convert.ToString(dr["CF_TypeName"]);
}
if (dr["CF_iType"] != DBNull.Value)
{
bse_File.CF_iType = Convert.ToString(dr["CF_iType"]);
}
if (dr["AuditStat"] != DBNull.Value)
{
bse_File.AuditStat = Convert.ToString(dr["AuditStat"]);
}
if (dr["AuditCurAudit"] != DBNull.Value)
{
bse_File.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
}
if (dr["CF_Bak"] != DBNull.Value)
{
bse_File.CF_Bak = Convert.ToString(dr["CF_Bak"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_File.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
if (dr["CF_Creator"] != DBNull.Value)
{
bse_File.CF_Creator = Convert.ToString(dr["CF_Creator"]);
}
if (dr["CF_CreatorName"] != DBNull.Value)
{
bse_File.CF_CreatorName = Convert.ToString(dr["CF_CreatorName"]);
}
ret.Add(bse_File);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的Bse_File对象集合
/// </summary>
public List <Bse_File> GetListByWhere(string strCondition)
{
List <Bse_File> ret = new List <Bse_File>();
string sql = "SELECT CF_ID,CF_Code,CF_Name,CF_Path,CF_Cate,CF_CateName,CF_Type,CF_TypeName,CF_iType,AuditStat,AuditCurAudit,CF_Bak,Stat,CreateTime,UpdateTime,DeleteTime,CF_Creator,CF_CreatorName FROM Bse_File WHERE 1=1 AND ((Stat is null) or (Stat=0) ) ";
if (!string.IsNullOrEmpty(strCondition))
{
strCondition.Replace('\'', '"'); //防sql注入
sql += strCondition;
}
sql += " ORDER BY CF_ID DESC ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Bse_File bse_File = new Bse_File();
if (dr["CF_ID"] != DBNull.Value)
{
bse_File.CF_ID = Convert.ToDecimal(dr["CF_ID"]);
}
if (dr["CF_Code"] != DBNull.Value)
{
bse_File.CF_Code = Convert.ToString(dr["CF_Code"]);
}
if (dr["CF_Name"] != DBNull.Value)
{
bse_File.CF_Name = Convert.ToString(dr["CF_Name"]);
}
if (dr["CF_Path"] != DBNull.Value)
{
bse_File.CF_Path = Convert.ToString(dr["CF_Path"]);
}
if (dr["CF_Cate"] != DBNull.Value)
{
bse_File.CF_Cate = Convert.ToString(dr["CF_Cate"]);
}
if (dr["CF_CateName"] != DBNull.Value)
{
bse_File.CF_CateName = Convert.ToString(dr["CF_CateName"]);
}
if (dr["CF_Type"] != DBNull.Value)
{
bse_File.CF_Type = Convert.ToString(dr["CF_Type"]);
}
if (dr["CF_TypeName"] != DBNull.Value)
{
bse_File.CF_TypeName = Convert.ToString(dr["CF_TypeName"]);
}
if (dr["CF_iType"] != DBNull.Value)
{
bse_File.CF_iType = Convert.ToString(dr["CF_iType"]);
}
if (dr["AuditStat"] != DBNull.Value)
{
bse_File.AuditStat = Convert.ToString(dr["AuditStat"]);
}
if (dr["AuditCurAudit"] != DBNull.Value)
{
bse_File.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
}
if (dr["CF_Bak"] != DBNull.Value)
{
bse_File.CF_Bak = Convert.ToString(dr["CF_Bak"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_File.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
if (dr["CF_Creator"] != DBNull.Value)
{
bse_File.CF_Creator = Convert.ToString(dr["CF_Creator"]);
}
if (dr["CF_CreatorName"] != DBNull.Value)
{
bse_File.CF_CreatorName = Convert.ToString(dr["CF_CreatorName"]);
}
ret.Add(bse_File);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
/// <summary>
/// 获取指定的Bse_File对象(即:一条记录
/// </summary>
public Bse_File GetByKey(decimal cF_ID)
{
Bse_File bse_File = new Bse_File();
string sql = "SELECT CF_ID,CF_Code,CF_Name,CF_Path,CF_Cate,CF_CateName,CF_Type,CF_TypeName,CF_iType,AuditStat,AuditCurAudit,CF_Bak,Stat,CreateTime,UpdateTime,DeleteTime,CF_Creator,CF_CreatorName FROM Bse_File WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND CF_ID=@CF_ID ";
idb.AddParameter("@CF_ID", cF_ID);
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
if (dr["CF_ID"] != DBNull.Value)
{
bse_File.CF_ID = Convert.ToDecimal(dr["CF_ID"]);
}
if (dr["CF_Code"] != DBNull.Value)
{
bse_File.CF_Code = Convert.ToString(dr["CF_Code"]);
}
if (dr["CF_Name"] != DBNull.Value)
{
bse_File.CF_Name = Convert.ToString(dr["CF_Name"]);
}
if (dr["CF_Path"] != DBNull.Value)
{
bse_File.CF_Path = Convert.ToString(dr["CF_Path"]);
}
if (dr["CF_Cate"] != DBNull.Value)
{
bse_File.CF_Cate = Convert.ToString(dr["CF_Cate"]);
}
if (dr["CF_CateName"] != DBNull.Value)
{
bse_File.CF_CateName = Convert.ToString(dr["CF_CateName"]);
}
if (dr["CF_Type"] != DBNull.Value)
{
bse_File.CF_Type = Convert.ToString(dr["CF_Type"]);
}
if (dr["CF_TypeName"] != DBNull.Value)
{
bse_File.CF_TypeName = Convert.ToString(dr["CF_TypeName"]);
}
if (dr["CF_iType"] != DBNull.Value)
{
bse_File.CF_iType = Convert.ToString(dr["CF_iType"]);
}
if (dr["AuditStat"] != DBNull.Value)
{
bse_File.AuditStat = Convert.ToString(dr["AuditStat"]);
}
if (dr["AuditCurAudit"] != DBNull.Value)
{
bse_File.AuditCurAudit = Convert.ToString(dr["AuditCurAudit"]);
}
if (dr["CF_Bak"] != DBNull.Value)
{
bse_File.CF_Bak = Convert.ToString(dr["CF_Bak"]);
}
if (dr["Stat"] != DBNull.Value)
{
bse_File.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateTime"] != DBNull.Value)
{
bse_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dr["UpdateTime"] != DBNull.Value)
{
bse_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]);
}
if (dr["DeleteTime"] != DBNull.Value)
{
bse_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]);
}
if (dr["CF_Creator"] != DBNull.Value)
{
bse_File.CF_Creator = Convert.ToString(dr["CF_Creator"]);
}
if (dr["CF_CreatorName"] != DBNull.Value)
{
bse_File.CF_CreatorName = Convert.ToString(dr["CF_CreatorName"]);
}
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(bse_File);
}
/// <summary>
/// 更新Bse_File对象(即:一条记录
/// </summary>
public int Update(Bse_File bse_File)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Bse_File SET ");
if (bse_File.CF_Code_IsChanged)
{
sbParameter.Append("CF_Code=@CF_Code, ");
}
if (bse_File.CF_Name_IsChanged)
{
sbParameter.Append("CF_Name=@CF_Name, ");
}
if (bse_File.CF_Path_IsChanged)
{
sbParameter.Append("CF_Path=@CF_Path, ");
}
if (bse_File.CF_Cate_IsChanged)
{
sbParameter.Append("CF_Cate=@CF_Cate, ");
}
if (bse_File.CF_CateName_IsChanged)
{
sbParameter.Append("CF_CateName=@CF_CateName, ");
}
if (bse_File.CF_Type_IsChanged)
{
sbParameter.Append("CF_Type=@CF_Type, ");
}
if (bse_File.CF_TypeName_IsChanged)
{
sbParameter.Append("CF_TypeName=@CF_TypeName, ");
}
if (bse_File.CF_iType_IsChanged)
{
sbParameter.Append("CF_iType=@CF_iType, ");
}
if (bse_File.AuditStat_IsChanged)
{
sbParameter.Append("AuditStat=@AuditStat, ");
}
if (bse_File.AuditCurAudit_IsChanged)
{
sbParameter.Append("AuditCurAudit=@AuditCurAudit, ");
}
if (bse_File.CF_Bak_IsChanged)
{
sbParameter.Append("CF_Bak=@CF_Bak, ");
}
if (bse_File.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (bse_File.CreateTime_IsChanged)
{
sbParameter.Append("CreateTime=@CreateTime, ");
}
if (bse_File.UpdateTime_IsChanged)
{
sbParameter.Append("UpdateTime=@UpdateTime, ");
}
if (bse_File.DeleteTime_IsChanged)
{
sbParameter.Append("DeleteTime=@DeleteTime, ");
}
if (bse_File.CF_Creator_IsChanged)
{
sbParameter.Append("CF_Creator=@CF_Creator, ");
}
if (bse_File.CF_CreatorName_IsChanged)
{
sbParameter.Append("CF_CreatorName=@CF_CreatorName ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CF_ID=@CF_ID; ");
string sql = sb.ToString();
if (bse_File.CF_Code_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Code))
{
idb.AddParameter("@CF_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Code", bse_File.CF_Code);
}
}
if (bse_File.CF_Name_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Name))
{
idb.AddParameter("@CF_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Name", bse_File.CF_Name);
}
}
if (bse_File.CF_Path_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Path))
{
idb.AddParameter("@CF_Path", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Path", bse_File.CF_Path);
}
}
if (bse_File.CF_Cate_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Cate))
{
idb.AddParameter("@CF_Cate", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Cate", bse_File.CF_Cate);
}
}
if (bse_File.CF_CateName_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_CateName))
{
idb.AddParameter("@CF_CateName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_CateName", bse_File.CF_CateName);
}
}
if (bse_File.CF_Type_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Type))
{
idb.AddParameter("@CF_Type", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Type", bse_File.CF_Type);
}
}
if (bse_File.CF_TypeName_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_TypeName))
{
idb.AddParameter("@CF_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_TypeName", bse_File.CF_TypeName);
}
}
if (bse_File.CF_iType_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_iType))
{
idb.AddParameter("@CF_iType", DBNull.Value);
}
else
{
idb.AddParameter("@CF_iType", bse_File.CF_iType);
}
}
if (bse_File.AuditStat_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", bse_File.AuditStat);
}
}
if (bse_File.AuditCurAudit_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", bse_File.AuditCurAudit);
}
}
if (bse_File.CF_Bak_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Bak))
{
idb.AddParameter("@CF_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Bak", bse_File.CF_Bak);
}
}
if (bse_File.Stat_IsChanged)
{
if (bse_File.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_File.Stat);
}
}
if (bse_File.CreateTime_IsChanged)
{
if (bse_File.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", bse_File.CreateTime);
}
}
if (bse_File.UpdateTime_IsChanged)
{
if (bse_File.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", bse_File.UpdateTime);
}
}
if (bse_File.DeleteTime_IsChanged)
{
if (bse_File.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", bse_File.DeleteTime);
}
}
if (bse_File.CF_Creator_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_Creator))
{
idb.AddParameter("@CF_Creator", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Creator", bse_File.CF_Creator);
}
}
if (bse_File.CF_CreatorName_IsChanged)
{
if (string.IsNullOrEmpty(bse_File.CF_CreatorName))
{
idb.AddParameter("@CF_CreatorName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_CreatorName", bse_File.CF_CreatorName);
}
}
idb.AddParameter("@CF_ID", bse_File.CF_ID);
return(idb.ExeCmd(sql));
}
/// <summary>
/// 添加Bse_File对象(即:一条记录)
/// </summary>
public int Add(Bse_File bse_File)
{
string sql = "INSERT INTO Bse_File (CF_Code,CF_Name,CF_Path,CF_Cate,CF_CateName,CF_Type,CF_TypeName,CF_iType,AuditStat,AuditCurAudit,CF_Bak,Stat,CreateTime,UpdateTime,DeleteTime,CF_Creator,CF_CreatorName) VALUES (@CF_Code,@CF_Name,@CF_Path,@CF_Cate,@CF_CateName,@CF_Type,@CF_TypeName,@CF_iType,@AuditStat,@AuditCurAudit,@CF_Bak,@Stat,@CreateTime,@UpdateTime,@DeleteTime,@CF_Creator,@CF_CreatorName)";
if (string.IsNullOrEmpty(bse_File.CF_Code))
{
idb.AddParameter("@CF_Code", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Code", bse_File.CF_Code);
}
if (string.IsNullOrEmpty(bse_File.CF_Name))
{
idb.AddParameter("@CF_Name", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Name", bse_File.CF_Name);
}
if (string.IsNullOrEmpty(bse_File.CF_Path))
{
idb.AddParameter("@CF_Path", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Path", bse_File.CF_Path);
}
if (string.IsNullOrEmpty(bse_File.CF_Cate))
{
idb.AddParameter("@CF_Cate", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Cate", bse_File.CF_Cate);
}
if (string.IsNullOrEmpty(bse_File.CF_CateName))
{
idb.AddParameter("@CF_CateName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_CateName", bse_File.CF_CateName);
}
if (string.IsNullOrEmpty(bse_File.CF_Type))
{
idb.AddParameter("@CF_Type", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Type", bse_File.CF_Type);
}
if (string.IsNullOrEmpty(bse_File.CF_TypeName))
{
idb.AddParameter("@CF_TypeName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_TypeName", bse_File.CF_TypeName);
}
if (string.IsNullOrEmpty(bse_File.CF_iType))
{
idb.AddParameter("@CF_iType", DBNull.Value);
}
else
{
idb.AddParameter("@CF_iType", bse_File.CF_iType);
}
if (string.IsNullOrEmpty(bse_File.AuditStat))
{
idb.AddParameter("@AuditStat", DBNull.Value);
}
else
{
idb.AddParameter("@AuditStat", bse_File.AuditStat);
}
if (string.IsNullOrEmpty(bse_File.AuditCurAudit))
{
idb.AddParameter("@AuditCurAudit", DBNull.Value);
}
else
{
idb.AddParameter("@AuditCurAudit", bse_File.AuditCurAudit);
}
if (string.IsNullOrEmpty(bse_File.CF_Bak))
{
idb.AddParameter("@CF_Bak", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Bak", bse_File.CF_Bak);
}
if (bse_File.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", bse_File.Stat);
}
if (bse_File.CreateTime == DateTime.MinValue)
{
idb.AddParameter("@CreateTime", DBNull.Value);
}
else
{
idb.AddParameter("@CreateTime", bse_File.CreateTime);
}
if (bse_File.UpdateTime == DateTime.MinValue)
{
idb.AddParameter("@UpdateTime", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateTime", bse_File.UpdateTime);
}
if (bse_File.DeleteTime == DateTime.MinValue)
{
idb.AddParameter("@DeleteTime", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteTime", bse_File.DeleteTime);
}
if (string.IsNullOrEmpty(bse_File.CF_Creator))
{
idb.AddParameter("@CF_Creator", DBNull.Value);
}
else
{
idb.AddParameter("@CF_Creator", bse_File.CF_Creator);
}
if (string.IsNullOrEmpty(bse_File.CF_CreatorName))
{
idb.AddParameter("@CF_CreatorName", DBNull.Value);
}
else
{
idb.AddParameter("@CF_CreatorName", bse_File.CF_CreatorName);
}
return(idb.ExeCmd(sql));
}
