/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCCase_Copyright GetModel(int n_CaseID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_CaseID,n_CFlowNum,s_SignName,n_CopyrightType,dt_CreationStart,dt_CreationEnd,n_Wordage,s_CompleteType,s_Published,dt_FirstPublished,s_FirstPublishAddr,s_ApplyAim,s_RightRange,dt_Apply,s_Register,dt_Register,s_AcceptNo,s_ReceiptNo,s_StoreNo,dt_Store,s_CopyrightStatus from TCCase_Copyright "); strSql.Append(" where n_CaseID=@n_CaseID "); SqlParameter[] parameters = { new SqlParameter("@n_CaseID", SqlDbType.Int, 4) }; parameters[0].Value = n_CaseID; IPSP.Model.TCCase_Copyright model = new IPSP.Model.TCCase_Copyright(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCCase_Copyright model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(IPSP.Model.TCCase_Copyright model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(IPSP.Model.TCCase_Copyright model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCCase_Copyright("); strSql.Append("n_CaseID,n_CFlowNum,s_SignName,n_CopyrightType,dt_CreationStart,dt_CreationEnd,n_Wordage,s_CompleteType,s_Published,dt_FirstPublished,s_FirstPublishAddr,s_ApplyAim,s_RightRange,dt_Apply,s_Register,dt_Register,s_AcceptNo,s_ReceiptNo,s_StoreNo,dt_Store,s_CopyrightStatus)"); strSql.Append(" values ("); strSql.Append("@n_CaseID,@n_CFlowNum,@s_SignName,@n_CopyrightType,@dt_CreationStart,@dt_CreationEnd,@n_Wordage,@s_CompleteType,@s_Published,@dt_FirstPublished,@s_FirstPublishAddr,@s_ApplyAim,@s_RightRange,@dt_Apply,@s_Register,@dt_Register,@s_AcceptNo,@s_ReceiptNo,@s_StoreNo,@dt_Store,@s_CopyrightStatus)"); SqlParameter[] parameters = { new SqlParameter("@n_CaseID", SqlDbType.Int, 4), new SqlParameter("@n_CFlowNum", SqlDbType.Int, 4), new SqlParameter("@s_SignName", SqlDbType.NVarChar, 50), new SqlParameter("@n_CopyrightType", SqlDbType.Int, 4), new SqlParameter("@dt_CreationStart", SqlDbType.DateTime), new SqlParameter("@dt_CreationEnd", SqlDbType.DateTime), new SqlParameter("@n_Wordage", SqlDbType.Int, 4), new SqlParameter("@s_CompleteType", SqlDbType.NVarChar, 50), new SqlParameter("@s_Published", SqlDbType.NVarChar, 1), new SqlParameter("@dt_FirstPublished", SqlDbType.DateTime), new SqlParameter("@s_FirstPublishAddr", SqlDbType.NVarChar, 500), new SqlParameter("@s_ApplyAim", SqlDbType.NVarChar, 500), new SqlParameter("@s_RightRange", SqlDbType.NVarChar, 1000), new SqlParameter("@dt_Apply", SqlDbType.DateTime), new SqlParameter("@s_Register", SqlDbType.NVarChar, 50), new SqlParameter("@dt_Register", SqlDbType.DateTime), new SqlParameter("@s_AcceptNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_ReceiptNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_StoreNo", SqlDbType.NVarChar, 50), new SqlParameter("@dt_Store", SqlDbType.DateTime), new SqlParameter("@s_CopyrightStatus", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.n_CaseID; parameters[1].Value = model.n_CFlowNum; parameters[2].Value = model.s_SignName; parameters[3].Value = model.n_CopyrightType; parameters[4].Value = model.dt_CreationStart; parameters[5].Value = model.dt_CreationEnd; parameters[6].Value = model.n_Wordage; parameters[7].Value = model.s_CompleteType; parameters[8].Value = model.s_Published; parameters[9].Value = model.dt_FirstPublished; parameters[10].Value = model.s_FirstPublishAddr; parameters[11].Value = model.s_ApplyAim; parameters[12].Value = model.s_RightRange; parameters[13].Value = model.dt_Apply; parameters[14].Value = model.s_Register; parameters[15].Value = model.dt_Register; parameters[16].Value = model.s_AcceptNo; parameters[17].Value = model.s_ReceiptNo; parameters[18].Value = model.s_StoreNo; parameters[19].Value = model.dt_Store; parameters[20].Value = model.s_CopyrightStatus; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCCase_Copyright DataRowToModel(DataRow row) { IPSP.Model.TCCase_Copyright model = new IPSP.Model.TCCase_Copyright(); if (row != null) { if (row["n_CaseID"] != null && row["n_CaseID"].ToString() != "") { model.n_CaseID = int.Parse(row["n_CaseID"].ToString()); } if (row["n_CFlowNum"] != null && row["n_CFlowNum"].ToString() != "") { model.n_CFlowNum = int.Parse(row["n_CFlowNum"].ToString()); } if (row["s_SignName"] != null) { model.s_SignName = row["s_SignName"].ToString(); } if (row["n_CopyrightType"] != null && row["n_CopyrightType"].ToString() != "") { model.n_CopyrightType = int.Parse(row["n_CopyrightType"].ToString()); } if (row["dt_CreationStart"] != null && row["dt_CreationStart"].ToString() != "") { model.dt_CreationStart = DateTime.Parse(row["dt_CreationStart"].ToString()); } if (row["dt_CreationEnd"] != null && row["dt_CreationEnd"].ToString() != "") { model.dt_CreationEnd = DateTime.Parse(row["dt_CreationEnd"].ToString()); } if (row["n_Wordage"] != null && row["n_Wordage"].ToString() != "") { model.n_Wordage = int.Parse(row["n_Wordage"].ToString()); } if (row["s_CompleteType"] != null) { model.s_CompleteType = row["s_CompleteType"].ToString(); } if (row["s_Published"] != null) { model.s_Published = row["s_Published"].ToString(); } if (row["dt_FirstPublished"] != null && row["dt_FirstPublished"].ToString() != "") { model.dt_FirstPublished = DateTime.Parse(row["dt_FirstPublished"].ToString()); } if (row["s_FirstPublishAddr"] != null) { model.s_FirstPublishAddr = row["s_FirstPublishAddr"].ToString(); } if (row["s_ApplyAim"] != null) { model.s_ApplyAim = row["s_ApplyAim"].ToString(); } if (row["s_RightRange"] != null) { model.s_RightRange = row["s_RightRange"].ToString(); } if (row["dt_Apply"] != null && row["dt_Apply"].ToString() != "") { model.dt_Apply = DateTime.Parse(row["dt_Apply"].ToString()); } if (row["s_Register"] != null) { model.s_Register = row["s_Register"].ToString(); } if (row["dt_Register"] != null && row["dt_Register"].ToString() != "") { model.dt_Register = DateTime.Parse(row["dt_Register"].ToString()); } if (row["s_AcceptNo"] != null) { model.s_AcceptNo = row["s_AcceptNo"].ToString(); } if (row["s_ReceiptNo"] != null) { model.s_ReceiptNo = row["s_ReceiptNo"].ToString(); } if (row["s_StoreNo"] != null) { model.s_StoreNo = row["s_StoreNo"].ToString(); } if (row["dt_Store"] != null && row["dt_Store"].ToString() != "") { model.dt_Store = DateTime.Parse(row["dt_Store"].ToString()); } if (row["s_CopyrightStatus"] != null) { model.s_CopyrightStatus = row["s_CopyrightStatus"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCCase_Copyright model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCCase_Copyright set "); strSql.Append("n_CFlowNum=@n_CFlowNum,"); strSql.Append("s_SignName=@s_SignName,"); strSql.Append("n_CopyrightType=@n_CopyrightType,"); strSql.Append("dt_CreationStart=@dt_CreationStart,"); strSql.Append("dt_CreationEnd=@dt_CreationEnd,"); strSql.Append("n_Wordage=@n_Wordage,"); strSql.Append("s_CompleteType=@s_CompleteType,"); strSql.Append("s_Published=@s_Published,"); strSql.Append("dt_FirstPublished=@dt_FirstPublished,"); strSql.Append("s_FirstPublishAddr=@s_FirstPublishAddr,"); strSql.Append("s_ApplyAim=@s_ApplyAim,"); strSql.Append("s_RightRange=@s_RightRange,"); strSql.Append("dt_Apply=@dt_Apply,"); strSql.Append("s_Register=@s_Register,"); strSql.Append("dt_Register=@dt_Register,"); strSql.Append("s_AcceptNo=@s_AcceptNo,"); strSql.Append("s_ReceiptNo=@s_ReceiptNo,"); strSql.Append("s_StoreNo=@s_StoreNo,"); strSql.Append("dt_Store=@dt_Store,"); strSql.Append("s_CopyrightStatus=@s_CopyrightStatus"); strSql.Append(" where n_CaseID=@n_CaseID "); SqlParameter[] parameters = { new SqlParameter("@n_CFlowNum", SqlDbType.Int, 4), new SqlParameter("@s_SignName", SqlDbType.NVarChar, 50), new SqlParameter("@n_CopyrightType", SqlDbType.Int, 4), new SqlParameter("@dt_CreationStart", SqlDbType.DateTime), new SqlParameter("@dt_CreationEnd", SqlDbType.DateTime), new SqlParameter("@n_Wordage", SqlDbType.Int, 4), new SqlParameter("@s_CompleteType", SqlDbType.NVarChar, 50), new SqlParameter("@s_Published", SqlDbType.NVarChar, 1), new SqlParameter("@dt_FirstPublished", SqlDbType.DateTime), new SqlParameter("@s_FirstPublishAddr", SqlDbType.NVarChar, 500), new SqlParameter("@s_ApplyAim", SqlDbType.NVarChar, 500), new SqlParameter("@s_RightRange", SqlDbType.NVarChar, 1000), new SqlParameter("@dt_Apply", SqlDbType.DateTime), new SqlParameter("@s_Register", SqlDbType.NVarChar, 50), new SqlParameter("@dt_Register", SqlDbType.DateTime), new SqlParameter("@s_AcceptNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_ReceiptNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_StoreNo", SqlDbType.NVarChar, 50), new SqlParameter("@dt_Store", SqlDbType.DateTime), new SqlParameter("@s_CopyrightStatus", SqlDbType.NVarChar, 50), new SqlParameter("@n_CaseID", SqlDbType.Int, 4) }; parameters[0].Value = model.n_CFlowNum; parameters[1].Value = model.s_SignName; parameters[2].Value = model.n_CopyrightType; parameters[3].Value = model.dt_CreationStart; parameters[4].Value = model.dt_CreationEnd; parameters[5].Value = model.n_Wordage; parameters[6].Value = model.s_CompleteType; parameters[7].Value = model.s_Published; parameters[8].Value = model.dt_FirstPublished; parameters[9].Value = model.s_FirstPublishAddr; parameters[10].Value = model.s_ApplyAim; parameters[11].Value = model.s_RightRange; parameters[12].Value = model.dt_Apply; parameters[13].Value = model.s_Register; parameters[14].Value = model.dt_Register; parameters[15].Value = model.s_AcceptNo; parameters[16].Value = model.s_ReceiptNo; parameters[17].Value = model.s_StoreNo; parameters[18].Value = model.dt_Store; parameters[19].Value = model.s_CopyrightStatus; parameters[20].Value = model.n_CaseID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }