/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TPCase_Patent GetModel(int n_CaseID, int n_LawID, int n_OrigPatInfoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_CaseID,n_PFlowNum,n_LawID,n_PatentTypeID,s_TechnologyType,s_OldSerial,s_NPatentID,s_OrigCaseSerial,s_OrigAppNo,dt_OrigAppDate,s_PatentStatus,s_Notes,n_OrigPatInfoID,s_Inventors,dt_RequestSubmitDate,b_DivisionalCaseFlag,s_OrigCaseNo,s_AllInventorAddress,s_FristPriority,s_FirstPriorityNo,dt_FirstPriorityDate,s_FirstInventor,s_PriorityStatus,dt_PriorityStatusDate,dt_DivSubmitDate,s_DivisionAppNo,s_DivisionCaseNo from TPCase_Patent "); strSql.Append(" where n_CaseID=@n_CaseID and n_LawID=@n_LawID and n_OrigPatInfoID=@n_OrigPatInfoID "); SqlParameter[] parameters = { new SqlParameter("@n_CaseID", SqlDbType.Int, 4), new SqlParameter("@n_LawID", SqlDbType.Int, 4), new SqlParameter("@n_OrigPatInfoID", SqlDbType.Int, 4) }; parameters[0].Value = n_CaseID; parameters[1].Value = n_LawID; parameters[2].Value = n_OrigPatInfoID; IPSP.Model.TPCase_Patent model = new IPSP.Model.TPCase_Patent(); 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 Add(IPSP.Model.TPCase_Patent model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPCase_Patent("); strSql.Append("n_CaseID,n_PFlowNum,n_LawID,n_PatentTypeID,s_TechnologyType,s_OldSerial,s_NPatentID,s_OrigCaseSerial,s_OrigAppNo,dt_OrigAppDate,s_PatentStatus,s_Notes,n_OrigPatInfoID,s_Inventors,dt_RequestSubmitDate,b_DivisionalCaseFlag,s_OrigCaseNo,s_AllInventorAddress,s_FristPriority,s_FirstPriorityNo,dt_FirstPriorityDate,s_FirstInventor,s_PriorityStatus,dt_PriorityStatusDate,dt_DivSubmitDate,s_DivisionAppNo,s_DivisionCaseNo)"); strSql.Append(" values ("); strSql.Append("@n_CaseID,@n_PFlowNum,@n_LawID,@n_PatentTypeID,@s_TechnologyType,@s_OldSerial,@s_NPatentID,@s_OrigCaseSerial,@s_OrigAppNo,@dt_OrigAppDate,@s_PatentStatus,@s_Notes,@n_OrigPatInfoID,@s_Inventors,@dt_RequestSubmitDate,@b_DivisionalCaseFlag,@s_OrigCaseNo,@s_AllInventorAddress,@s_FristPriority,@s_FirstPriorityNo,@dt_FirstPriorityDate,@s_FirstInventor,@s_PriorityStatus,@dt_PriorityStatusDate,@dt_DivSubmitDate,@s_DivisionAppNo,@s_DivisionCaseNo)"); SqlParameter[] parameters = { new SqlParameter("@n_CaseID", SqlDbType.Int, 4), new SqlParameter("@n_PFlowNum", SqlDbType.Int, 4), new SqlParameter("@n_LawID", SqlDbType.Int, 4), new SqlParameter("@n_PatentTypeID", SqlDbType.Int, 4), new SqlParameter("@s_TechnologyType", SqlDbType.NVarChar, 50), new SqlParameter("@s_OldSerial", SqlDbType.NVarChar, 20), new SqlParameter("@s_NPatentID", SqlDbType.NVarChar, 50), new SqlParameter("@s_OrigCaseSerial", SqlDbType.NVarChar, 50), new SqlParameter("@s_OrigAppNo", SqlDbType.NVarChar, 50), new SqlParameter("@dt_OrigAppDate", SqlDbType.DateTime), new SqlParameter("@s_PatentStatus", SqlDbType.NVarChar, 50), new SqlParameter("@s_Notes", SqlDbType.NVarChar, 800), new SqlParameter("@n_OrigPatInfoID", SqlDbType.Int, 4), new SqlParameter("@s_Inventors", SqlDbType.NVarChar, 1000), new SqlParameter("@dt_RequestSubmitDate", SqlDbType.DateTime), new SqlParameter("@b_DivisionalCaseFlag", SqlDbType.Bit, 1), new SqlParameter("@s_OrigCaseNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_AllInventorAddress", SqlDbType.NVarChar, 500), new SqlParameter("@s_FristPriority", SqlDbType.NVarChar, 500), new SqlParameter("@s_FirstPriorityNo", SqlDbType.NVarChar, 500), new SqlParameter("@dt_FirstPriorityDate", SqlDbType.DateTime), new SqlParameter("@s_FirstInventor", SqlDbType.NVarChar, 200), new SqlParameter("@s_PriorityStatus", SqlDbType.NVarChar, 1), new SqlParameter("@dt_PriorityStatusDate", SqlDbType.DateTime), new SqlParameter("@dt_DivSubmitDate", SqlDbType.DateTime), new SqlParameter("@s_DivisionAppNo", SqlDbType.NVarChar, 50), new SqlParameter("@s_DivisionCaseNo", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.n_CaseID; parameters[1].Value = model.n_PFlowNum; parameters[2].Value = model.n_LawID; parameters[3].Value = model.n_PatentTypeID; parameters[4].Value = model.s_TechnologyType; parameters[5].Value = model.s_OldSerial; parameters[6].Value = model.s_NPatentID; parameters[7].Value = model.s_OrigCaseSerial; parameters[8].Value = model.s_OrigAppNo; parameters[9].Value = model.dt_OrigAppDate; parameters[10].Value = model.s_PatentStatus; parameters[11].Value = model.s_Notes; parameters[12].Value = model.n_OrigPatInfoID; parameters[13].Value = model.s_Inventors; parameters[14].Value = model.dt_RequestSubmitDate; parameters[15].Value = model.b_DivisionalCaseFlag; parameters[16].Value = model.s_OrigCaseNo; parameters[17].Value = model.s_AllInventorAddress; parameters[18].Value = model.s_FristPriority; parameters[19].Value = model.s_FirstPriorityNo; parameters[20].Value = model.dt_FirstPriorityDate; parameters[21].Value = model.s_FirstInventor; parameters[22].Value = model.s_PriorityStatus; parameters[23].Value = model.dt_PriorityStatusDate; parameters[24].Value = model.dt_DivSubmitDate; parameters[25].Value = model.s_DivisionAppNo; parameters[26].Value = model.s_DivisionCaseNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TPCase_Patent DataRowToModel(DataRow row) { IPSP.Model.TPCase_Patent model = new IPSP.Model.TPCase_Patent(); if (row != null) { if (row["n_CaseID"] != null && row["n_CaseID"].ToString() != "") { model.n_CaseID = int.Parse(row["n_CaseID"].ToString()); } if (row["n_PFlowNum"] != null && row["n_PFlowNum"].ToString() != "") { model.n_PFlowNum = int.Parse(row["n_PFlowNum"].ToString()); } if (row["n_LawID"] != null && row["n_LawID"].ToString() != "") { model.n_LawID = int.Parse(row["n_LawID"].ToString()); } if (row["n_PatentTypeID"] != null && row["n_PatentTypeID"].ToString() != "") { model.n_PatentTypeID = int.Parse(row["n_PatentTypeID"].ToString()); } if (row["s_TechnologyType"] != null) { model.s_TechnologyType = row["s_TechnologyType"].ToString(); } if (row["s_OldSerial"] != null) { model.s_OldSerial = row["s_OldSerial"].ToString(); } if (row["s_NPatentID"] != null) { model.s_NPatentID = row["s_NPatentID"].ToString(); } if (row["s_OrigCaseSerial"] != null) { model.s_OrigCaseSerial = row["s_OrigCaseSerial"].ToString(); } if (row["s_OrigAppNo"] != null) { model.s_OrigAppNo = row["s_OrigAppNo"].ToString(); } if (row["dt_OrigAppDate"] != null && row["dt_OrigAppDate"].ToString() != "") { model.dt_OrigAppDate = DateTime.Parse(row["dt_OrigAppDate"].ToString()); } if (row["s_PatentStatus"] != null) { model.s_PatentStatus = row["s_PatentStatus"].ToString(); } if (row["s_Notes"] != null) { model.s_Notes = row["s_Notes"].ToString(); } if (row["n_OrigPatInfoID"] != null && row["n_OrigPatInfoID"].ToString() != "") { model.n_OrigPatInfoID = int.Parse(row["n_OrigPatInfoID"].ToString()); } if (row["s_Inventors"] != null) { model.s_Inventors = row["s_Inventors"].ToString(); } if (row["dt_RequestSubmitDate"] != null && row["dt_RequestSubmitDate"].ToString() != "") { model.dt_RequestSubmitDate = DateTime.Parse(row["dt_RequestSubmitDate"].ToString()); } if (row["b_DivisionalCaseFlag"] != null && row["b_DivisionalCaseFlag"].ToString() != "") { if ((row["b_DivisionalCaseFlag"].ToString() == "1") || (row["b_DivisionalCaseFlag"].ToString().ToLower() == "true")) { model.b_DivisionalCaseFlag = true; } else { model.b_DivisionalCaseFlag = false; } } if (row["s_OrigCaseNo"] != null) { model.s_OrigCaseNo = row["s_OrigCaseNo"].ToString(); } if (row["s_AllInventorAddress"] != null) { model.s_AllInventorAddress = row["s_AllInventorAddress"].ToString(); } if (row["s_FristPriority"] != null) { model.s_FristPriority = row["s_FristPriority"].ToString(); } if (row["s_FirstPriorityNo"] != null) { model.s_FirstPriorityNo = row["s_FirstPriorityNo"].ToString(); } if (row["dt_FirstPriorityDate"] != null && row["dt_FirstPriorityDate"].ToString() != "") { model.dt_FirstPriorityDate = DateTime.Parse(row["dt_FirstPriorityDate"].ToString()); } if (row["s_FirstInventor"] != null) { model.s_FirstInventor = row["s_FirstInventor"].ToString(); } if (row["s_PriorityStatus"] != null) { model.s_PriorityStatus = row["s_PriorityStatus"].ToString(); } if (row["dt_PriorityStatusDate"] != null && row["dt_PriorityStatusDate"].ToString() != "") { model.dt_PriorityStatusDate = DateTime.Parse(row["dt_PriorityStatusDate"].ToString()); } if (row["dt_DivSubmitDate"] != null && row["dt_DivSubmitDate"].ToString() != "") { model.dt_DivSubmitDate = DateTime.Parse(row["dt_DivSubmitDate"].ToString()); } if (row["s_DivisionAppNo"] != null) { model.s_DivisionAppNo = row["s_DivisionAppNo"].ToString(); } if (row["s_DivisionCaseNo"] != null) { model.s_DivisionCaseNo = row["s_DivisionCaseNo"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TPCase_Patent model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(IPSP.Model.TPCase_Patent model) { return(dal.Add(model)); }