/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.File GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,file_name,type,pwd,pwdflag,up_person,up_date,updata_person,updata_datetiem,cate_id,flieGuid,withoutID,activate,Remark,value,value1,value2,value3,value4,value5,value6,value7,value8,value9 from [File] ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.File model = new Maticsoft.Model.File();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["file_name"] != null && ds.Tables[0].Rows[0]["file_name"].ToString() != "")
{
model.file_name = ds.Tables[0].Rows[0]["file_name"].ToString();
}
if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = ds.Tables[0].Rows[0]["type"].ToString();
}
if (ds.Tables[0].Rows[0]["pwd"] != null && ds.Tables[0].Rows[0]["pwd"].ToString() != "")
{
model.pwd = ds.Tables[0].Rows[0]["pwd"].ToString();
}
if (ds.Tables[0].Rows[0]["pwdflag"] != null && ds.Tables[0].Rows[0]["pwdflag"].ToString() != "")
{
model.pwdflag = int.Parse(ds.Tables[0].Rows[0]["pwdflag"].ToString());
}
if (ds.Tables[0].Rows[0]["up_person"] != null && ds.Tables[0].Rows[0]["up_person"].ToString() != "")
{
model.up_person = int.Parse(ds.Tables[0].Rows[0]["up_person"].ToString());
}
if (ds.Tables[0].Rows[0]["up_date"] != null && ds.Tables[0].Rows[0]["up_date"].ToString() != "")
{
model.up_date = DateTime.Parse(ds.Tables[0].Rows[0]["up_date"].ToString());
}
if (ds.Tables[0].Rows[0]["updata_person"] != null && ds.Tables[0].Rows[0]["updata_person"].ToString() != "")
{
model.updata_person = int.Parse(ds.Tables[0].Rows[0]["updata_person"].ToString());
}
if (ds.Tables[0].Rows[0]["updata_datetiem"] != null && ds.Tables[0].Rows[0]["updata_datetiem"].ToString() != "")
{
model.updata_datetiem = DateTime.Parse(ds.Tables[0].Rows[0]["updata_datetiem"].ToString());
}
if (ds.Tables[0].Rows[0]["cate_id"] != null && ds.Tables[0].Rows[0]["cate_id"].ToString() != "")
{
model.cate_id = int.Parse(ds.Tables[0].Rows[0]["cate_id"].ToString());
}
if (ds.Tables[0].Rows[0]["flieGuid"] != null && ds.Tables[0].Rows[0]["flieGuid"].ToString() != "")
{
model.flieGuid = ds.Tables[0].Rows[0]["flieGuid"].ToString();
}
if (ds.Tables[0].Rows[0]["withoutID"] != null && ds.Tables[0].Rows[0]["withoutID"].ToString() != "")
{
model.withoutID = int.Parse(ds.Tables[0].Rows[0]["withoutID"].ToString());
}
if (ds.Tables[0].Rows[0]["activate"] != null && ds.Tables[0].Rows[0]["activate"].ToString() != "")
{
model.activate = int.Parse(ds.Tables[0].Rows[0]["activate"].ToString());
}
if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "")
{
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = ds.Tables[0].Rows[0]["value"].ToString();
}
if (ds.Tables[0].Rows[0]["value1"] != null && ds.Tables[0].Rows[0]["value1"].ToString() != "")
{
model.value1 = ds.Tables[0].Rows[0]["value1"].ToString();
}
if (ds.Tables[0].Rows[0]["value2"] != null && ds.Tables[0].Rows[0]["value2"].ToString() != "")
{
model.value2 = ds.Tables[0].Rows[0]["value2"].ToString();
}
if (ds.Tables[0].Rows[0]["value3"] != null && ds.Tables[0].Rows[0]["value3"].ToString() != "")
{
model.value3 = ds.Tables[0].Rows[0]["value3"].ToString();
}
if (ds.Tables[0].Rows[0]["value4"] != null && ds.Tables[0].Rows[0]["value4"].ToString() != "")
{
model.value4 = ds.Tables[0].Rows[0]["value4"].ToString();
}
if (ds.Tables[0].Rows[0]["value5"] != null && ds.Tables[0].Rows[0]["value5"].ToString() != "")
{
model.value5 = ds.Tables[0].Rows[0]["value5"].ToString();
}
if (ds.Tables[0].Rows[0]["value6"] != null && ds.Tables[0].Rows[0]["value6"].ToString() != "")
{
model.value6 = ds.Tables[0].Rows[0]["value6"].ToString();
}
if (ds.Tables[0].Rows[0]["value7"] != null && ds.Tables[0].Rows[0]["value7"].ToString() != "")
{
model.value7 = ds.Tables[0].Rows[0]["value7"].ToString();
}
if (ds.Tables[0].Rows[0]["value8"] != null && ds.Tables[0].Rows[0]["value8"].ToString() != "")
{
model.value8 = ds.Tables[0].Rows[0]["value8"].ToString();
}
if (ds.Tables[0].Rows[0]["value9"] != null && ds.Tables[0].Rows[0]["value9"].ToString() != "")
{
model.value9 = ds.Tables[0].Rows[0]["value9"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.File model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [File](");
strSql.Append("file_name,type,pwd,pwdflag,up_person,up_date,updata_person,updata_datetiem,cate_id,flieGuid,withoutID,activate,Remark,value,value1,value2,value3,value4,value5,value6,value7,value8,value9)");
strSql.Append(" values (");
strSql.Append("@file_name,@type,@pwd,@pwdflag,@up_person,@up_date,@updata_person,@updata_datetiem,@cate_id,@flieGuid,@withoutID,@activate,@Remark,@value,@value1,@value2,@value3,@value4,@value5,@value6,@value7,@value8,@value9)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@file_name", SqlDbType.NVarChar, 255),
new SqlParameter("@type", SqlDbType.NVarChar, 50),
new SqlParameter("@pwd", SqlDbType.NVarChar, 255),
new SqlParameter("@pwdflag", SqlDbType.Int, 4),
new SqlParameter("@up_person", SqlDbType.Int, 4),
new SqlParameter("@up_date", SqlDbType.DateTime),
new SqlParameter("@updata_person", SqlDbType.Int, 4),
new SqlParameter("@updata_datetiem", SqlDbType.DateTime),
new SqlParameter("@cate_id", SqlDbType.Int, 4),
new SqlParameter("@flieGuid", SqlDbType.NVarChar),
new SqlParameter("@withoutID", SqlDbType.Int, 4),
new SqlParameter("@activate", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@value", SqlDbType.NVarChar),
new SqlParameter("@value1", SqlDbType.NVarChar),
new SqlParameter("@value2", SqlDbType.NVarChar),
new SqlParameter("@value3", SqlDbType.NVarChar),
new SqlParameter("@value4", SqlDbType.NVarChar),
new SqlParameter("@value5", SqlDbType.NVarChar),
new SqlParameter("@value6", SqlDbType.NVarChar),
new SqlParameter("@value7", SqlDbType.NVarChar),
new SqlParameter("@value8", SqlDbType.NVarChar),
new SqlParameter("@value9", SqlDbType.NVarChar)
};
parameters[0].Value = model.file_name;
parameters[1].Value = model.type;
parameters[2].Value = model.pwd;
parameters[3].Value = model.pwdflag;
parameters[4].Value = model.up_person;
parameters[5].Value = model.up_date;
parameters[6].Value = model.updata_person;
parameters[7].Value = model.updata_datetiem;
parameters[8].Value = model.cate_id;
parameters[9].Value = model.flieGuid;
parameters[10].Value = model.withoutID;
parameters[11].Value = model.activate;
parameters[12].Value = model.Remark;
parameters[13].Value = model.value;
parameters[14].Value = model.value1;
parameters[15].Value = model.value2;
parameters[16].Value = model.value3;
parameters[17].Value = model.value4;
parameters[18].Value = model.value5;
parameters[19].Value = model.value6;
parameters[20].Value = model.value7;
parameters[21].Value = model.value8;
parameters[22].Value = model.value9;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.File model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [File] set ");
strSql.Append("file_name=@file_name,");
strSql.Append("pwd=@pwd,");
strSql.Append("pwdflag=@pwdflag,");
strSql.Append("updata_person=@updata_person,");
strSql.Append("updata_datetiem=@updata_datetiem,");
strSql.Append("Remark=@Remark,");
strSql.Append("value=@value,");
strSql.Append("value1=@value1,");
strSql.Append("value2=@value2,");
strSql.Append("value3=@value3,");
strSql.Append("value4=@value4,");
strSql.Append("value5=@value5,");
strSql.Append("value6=@value6,");
strSql.Append("value7=@value7,");
strSql.Append("value8=@value8,");
strSql.Append("value9=@value9");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@file_name", SqlDbType.NVarChar, 255),
new SqlParameter("@pwd", SqlDbType.NVarChar, 255),
new SqlParameter("@pwdflag", SqlDbType.Int, 4),
new SqlParameter("@updata_person", SqlDbType.Int, 4),
new SqlParameter("@updata_datetiem", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@value", SqlDbType.NVarChar),
new SqlParameter("@value1", SqlDbType.NVarChar),
new SqlParameter("@value2", SqlDbType.NVarChar),
new SqlParameter("@value3", SqlDbType.NVarChar),
new SqlParameter("@value4", SqlDbType.NVarChar),
new SqlParameter("@value5", SqlDbType.NVarChar),
new SqlParameter("@value6", SqlDbType.NVarChar),
new SqlParameter("@value7", SqlDbType.NVarChar),
new SqlParameter("@value8", SqlDbType.NVarChar),
new SqlParameter("@value9", SqlDbType.NVarChar),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.file_name;
parameters[1].Value = model.pwd;
parameters[2].Value = model.pwdflag;
parameters[3].Value = model.updata_person;
parameters[4].Value = model.updata_datetiem;
parameters[5].Value = model.Remark;
parameters[6].Value = model.value;
parameters[7].Value = model.value1;
parameters[8].Value = model.value2;
parameters[9].Value = model.value3;
parameters[10].Value = model.value4;
parameters[11].Value = model.value5;
parameters[12].Value = model.value6;
parameters[13].Value = model.value7;
parameters[14].Value = model.value8;
parameters[15].Value = model.value9;
parameters[16].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
