/// <summary> /// ��model��ij��˱�ʶΪIdentity,Timestamp֮�������ֵ�������ݿ� /// </summary> /// <param name="model">��Ҫ�������ݿ��model</param> /// <returns>Ӱ��ļ�¼��</returns> public virtual int Insert(Model model) { model.GmtCreateUser = this.Operater; model.GmtCreateDate = DateTime.Now; model.GmtUpdateUser = this.Operater; model.GmtUpdateDate = DateTime.Now; ParmCollection parms = this.Table.PrepareNotIdentityParms(model); return(Internal_DataHelper.ExecuteNonQuery(this.Table.Insert, parms)); }
/// <summary> /// ����Key�ֶ���Ϊɾ��������model��������κ�ֵ��������Ϊɾ��������ֻ�б�ʶΪKey���ֶβŻ���Ϊɾ������ /// </summary> /// <param name="models">��Ϊ������model����</param> /// <returns>Ӱ��ļ�¼��</returns> public virtual int DeleteWithKeys(params Model[] models) { int returnCount = 0; foreach (var model in models) { ParmCollection parms = this.Table.PrepareKeysParms(model); returnCount += Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, parms.WhereSql), parms); } return(returnCount); }
/// <summary> /// ���������ֶ���Ϊɾ������ /// </summary> /// <param name="identitys">�Զ�����ֵ����</param> /// <returns>Ӱ��ļ�¼��</returns> public virtual int DeleteWithIdentity(params long[] identitys) { int returnCount = 0; foreach (var identity in identitys) { ParmCollection parm = this.Table.PrepareIdentityParm(identity); returnCount += Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, parm.WhereSql), parm); } return(returnCount); }
/// <summary> /// ��model�������modelÿ�����˱�ʶΪIdentity,Timestamp֮�������ֵ�������ݿ� /// </summary> /// <param name="models">��Ҫ�������ݿ��</param> /// <returns>Ӱ��ļ�¼��</returns> public virtual int InsertCol(Model[] models) { int num = 0; Collection <StringBuilder> sc = this.Table.PrepareInsertCol <Model, OutputModel>(models, this.Operater); foreach (StringBuilder s in sc) { num += Internal_DataHelper.ExecuteNonQuery(s.ToString()); } return(num); }
/// <summary> /// ������ձ���ȫ������ /// ��������־������Truncate Table ���� /// </summary> public virtual void TruncateTable() { Internal_DataHelper.ExecuteNonQuery(string.Format("TRUNCATE TABLE {0}", this.Table.TableName)); }
/// <summary> /// ɾ��ȫ����¼ /// </summary> /// <returns>Ӱ��ļ�¼��</returns> public virtual int DeleteAll() { return(Internal_DataHelper.ExecuteNonQuery(string.Format(this.Table.Delete, string.Empty))); }