/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DJK.Model.admin_MedicalSource model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into admin_MedicalSource(");
strSql.Append("MedicalID,Source,SourceTable,sourceNum,SourceID)");
strSql.Append(" values (");
strSql.Append("@MedicalID,@Source,@SourceTable,@sourceNum,@SourceID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MedicalID", SqlDbType.Int, 4),
new SqlParameter("@Source", SqlDbType.NVarChar, 50),
new SqlParameter("@SourceTable", SqlDbType.NVarChar, 50),
new SqlParameter("@sourceNum", SqlDbType.Int, 4),
new SqlParameter("@sourceID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MedicalID;
parameters[1].Value = model.Source;
parameters[2].Value = model.SourceTable;
parameters[3].Value = model.SourceNum;
parameters[4].Value = model.SourceID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DJK.Model.admin_MedicalSource DataRowToModel(DataRow row)
{
DJK.Model.admin_MedicalSource model = new DJK.Model.admin_MedicalSource();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["MedicalID"] != null && row["MedicalID"].ToString() != "")
{
model.MedicalID = int.Parse(row["MedicalID"].ToString());
}
if (row["Source"] != null)
{
model.Source = row["Source"].ToString();
}
if (row["SourceTable"] != null)
{
model.SourceTable = row["SourceTable"].ToString();
}
if (row["sourceNum"] != null && row["sourceNum"].ToString() != "")
{
model.SourceNum = int.Parse(row["sourceNum"].ToString());
}
if (row["SourceID"] != null && row["SourceID"].ToString() != "")
{
model.SourceID = int.Parse(row["SourceID"].ToString());
}
}
return(model);
}
public List <DJK.Model.admin_MedicalSource> getModelList(int medicalID)
{
DataTable dt = GetList("medicalID=" + medicalID).Tables[0];
List <DJK.Model.admin_MedicalSource> list = new List <Model.admin_MedicalSource>();
foreach (DataRow dr in dt.Rows)
{
DJK.Model.admin_MedicalSource model = DataRowToModel(dr);
list.Add(model);
}
return(list);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DJK.Model.admin_MedicalSource model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update admin_MedicalSource set ");
strSql.Append("MedicalID=@MedicalID,");
strSql.Append("Source=@Source,");
strSql.Append("SourceTable=@SourceTable,");
strSql.Append("sourceNum=@sourceNum,");
strSql.Append("sourceID=@sourceID,");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@MedicalID", SqlDbType.Int, 4),
new SqlParameter("@Source", SqlDbType.NVarChar, 50),
new SqlParameter("@SourceTable", SqlDbType.NVarChar, 50),
new SqlParameter("@sourceNum", SqlDbType.Int, 4),
new SqlParameter("@sourceID", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MedicalID;
parameters[1].Value = model.Source;
parameters[2].Value = model.SourceTable;
parameters[3].Value = model.SourceNum;
parameters[4].Value = model.SourceID;
parameters[5].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DJK.Model.admin_MedicalSource GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MedicalID,Source,SourceTable,sourceNum,SourceID from admin_MedicalSource ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
DJK.Model.admin_MedicalSource model = new DJK.Model.admin_MedicalSource();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
