��

��תGOOGLE--playGoogle.com

karry — Fri, 27 Jun 2008 00:31:27 +0800

ȫ��blog:

��--��Micrsoft EnterpriseLibrary

karry — Tue, 15 Jan 2008 19:12:31 +0800

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;

///

/// ��
///

public class TransactionHandle
{
public TransactionHandle()
{
  //
  // TODO: �ڴ˴��ӹ��캯��߼�
  //
}
    ///

/// ȡ��
///

    /// ��ID
    /// ��ԱID
    ///
    public bool CancelOrder(int OrderId,int MemberId,int useScroe,float useBalance)
    {
        OrderDetail od = new OrderDetail();
        Product pro = new Product();
        subProduct subPro = new subProduct();
        ProductStock proStock = new ProductStock();
        Database db = DatabaseFactory.CreateDatabase();
        ///��ʼ��
        using (DbConnection conn = db.CreateConnection())
        {
            conn.Open();
            DbTransaction transaction = conn.BeginTransaction();
            try
            {
                //��ȡ��ز�Ʒ
                od.orderId = OrderId;
                DataTable dt = od.getProListByOrderId(transaction,db);
                //��²�Ʒ��
                foreach (DataRow dr in dt.Rows)
                {
                    pro.proId = int.Parse(dr["Pro_Id"].ToString());
                    //��
                    int num = int.Parse(dr["pro_Num"].ToString());
                    int isCuxiao = int.Parse(dr["Pro_IsCuxiao"].ToString());
                    if (pro.updateStore(pro.proId, num, transaction, db))
                    {
                        //��Ϊ��Ʒ��´��
                        if (isCuxiao == 1)
                        {
                            if (!pro.updateCuxiaoNum(num, transaction, db))
                            {
                                transaction.Rollback();
                                return false;
                            }
                        }
                        subPro.pro_Sub_No = dr["sub_Pro_No"].ToString();
                        //��Ʒ��
                        if (subPro.updateStore(subPro.pro_Sub_No, num, transaction, db))
                        {
                            //��¿��ˮ��
                            proStock.proNo = subPro.pro_Sub_No;
                            proStock.stockChangeTime = DateTime.Now;
                            proStock.stockChangeNum = num;
                            if (!proStock.addStock(transaction, db))
                            {
                                transaction.Rollback();
                                return false;
                            }
                        }
                        else
                        {
                            transaction.Rollback();
                            return false;
                        }

                    }
                    else
                    {
                        transaction.Rollback();
                        return false;
                    }
                }
                //��¶��Ա��֡��
                Order order = new Order();
                order.orderId = OrderId;
                order.orderStatus = 6;
                if (order.upDateStatusByOrderId())
                {
                    Member mem = new Member();
                    mem.MemberId = MemberId;
                    //��»��֡��
                    if (mem.updateScoreAndBalance(useScroe, useBalance, transaction, db))
                    {
                        //��»��ϸ��

                        return true;
                    }
                    else
                    {
                        transaction.Rollback();
                        return false;
                    }
                }
                else
                {
                    return false;
                }

            }
            catch(Exception e)
            {
                transaction.Rollback();
                return false;
            }
        }

}

Jmail(c#) ��ʼ��ȫ��

karry — Sat, 29 Dec 2007 20:54:43 +0800

ʹ��Jmail�齨��ʼ��HTML ��ʽ

��嵥��

using jmail;

using System.Net;

///

/// Email ��ժҪ˵��

///

public class Email

{

public static string fromMail = "service@ecggw.com";

public static string password = "��";

public static string smtpServer = "mail.ecggw.com";

public Email()

{

}

///

/// ��ʼ� û�г��

///

/// ��ʼ��

/// ��

/// �ʼ��

///

public static bool sendMail(string userMail,string userName,string mailTitle, string mailContent)

{

jmail.Message jmessage = new jmail.MessageClass();

jmessage.Charset = "GB2312";

jmessage.From = fromMail;

jmessage.FromName = "karry";

jmessage.ReplyTo = userMail;

jmessage.Subject = mailTitle;

jmessage.ContentType = "text/html";

jmessage.AddRecipient(userMail, userName, "123");

jmessage.Body = mailContent;

jmessage.MailServerUserName = fromMail;

jmessage.MailServerPassWord = password;

jmessage.Send(smtpServer, false);

jmessage.Close();

return true;

}

///

/// ��ط��ʼ� �г��

///

/// ��ʼ��

/// ��

/// �ʼ��

///

public static bool sendMail(string userMail,string copyMail, string userName, string mailTitle, string mailContent)

{

jmail.Message jmessage = new jmail.MessageClass();

jmessage.Charset = "GB2312";

jmessage.From = fromMail;

jmessage.FromName = userName;

jmessage.ReplyTo = userMail;

jmessage.Subject = mailTitle;

jmessage.ContentType = "text/html";

jmessage.AddRecipient(userMail,"", "123");

jmessage.AddRecipientCC(copyMail,"", "123");

jmessage.Body = mailContent;

jmessage.MailServerUserName = fromMail;

jmessage.MailServerPassWord = password;

jmessage.Send(smtpServer, false);

jmessage.Close();

return true;

}

///

/// ��ָ��ҳ��ɾ�̬��ַ��

///

/// ҳ��URL��ַ

/// ��ɵ��ַ�

public static string getPageString(string aspxPageUrl)

{

string content = string.Empty;

try

{

System.Net.WebRequest wr = WebRequest.Create(aspxPageUrl);

System.Net.WebResponse wrs = wr.GetResponse();

System.IO.StreamReader sr = new System.IO.StreamReader(wrs.GetResponseStream(), System.Text.Encoding.GetEncoding("utf-8"));

content = sr.ReadToEnd();

sr.Close();

}

catch

{

}

return content;

}

///

/// ��ȡ�ַ��ָ��ַ��ڳ��ָ��λ��

///

/// �ַ��

/// ָ��ַ�

/// ָ��ĳ��ִ��

///

public static int getIndexOf(string str1,char myChar, int myCount)

{

char[] charArr = str1.ToCharArray();

int count = 0;

int j = 0;

for (int i = 0; i < charArr.Length; i++)

{

j++;

if (charArr[i] == myChar)

{

count++;

}

if (count == myCount)

{

return j;

}

return j;

}

�Զ��ҳ��ȫ��

karry — Mon, 12 Nov 2007 22:49:57 +0800

��û�ɱ�ģ��һ��ҳ��

��ʼ��һ��Զ��û��ؼ�.ascx��Լ��ܴ��ɡ��Ϊ��ҳҪ�븴�ӵ��ܽ��һ��Ҳ�� url��ʺô��ַ�ʽ��ѡ��postBack��ƣ��һ��˺ܶ�ʱ��Զ��û��ؼ��еİ�ť��ĸ�ҳ��ķ��û�гɹ��˱��д��һ��ؼ�ASPNETPAGER��

��ҳ��ǰ��ݶ�ȡ��ֻȡ��ǰҳ��ݣ�ͬʱ��ϣ��ҳ�ؼ��Ե��κεط�ʹ�ã��Ҫһ��ͨ�õĴ洢��:

CREATE PROCEDURE Pagination

@tblName varchar(255), -- ��

@strGetFields varchar(1000) = '*', -- ��Ҫ��ص��

@fldName varchar(255)='', -- ��ֶ��

@PageSize int = 10, -- ҳ�ߴ�

@PageIndex int = 1, -- ҳ��

@doCount bit = 0, -- ��ؼ�¼��, �� 0 ֵ�򷵻�

@OrderType bit = 0, -- ��, �� 0 ֵ��

@strWhere varchar(1500) = '' -- ��ѯ�� (ע��: ��Ҫ�� where)

declare @strSQL varchar(5000) -- ��

declare @strTmp varchar(110) -- ��ʱ��

declare @strOrder varchar(400) -- ��

if @doCount != 0

begin

if @strWhere !=''

set @strSQL = 'select count(*) as Total from ['+ @tblName +'] where '+ @strWhere

else

set @strSQL = 'select count(*) as Total from ['+ @tblName +']'

end

--��ϴ��˼��@doCount��ݹ��Ĳ��0��ִ��ͳ�ơ��µ��д��붼

--��@doCountΪ0��

else

begin

if @OrderType != 0

begin

set @strTmp = '<(select min'

set @strOrder = ' order by ['+ @fldName +'] desc'

--��@OrderType��0��ִ�н��Ҫ��

end

else

begin

set @strTmp = '>(select max'

set @strOrder = ' order by ['+ @fldName +'] asc'

end

if @PageIndex = 1

begin

if @strWhere != ''

set @strSQL = 'select top ' + str(@PageSize) +' + ' from ['+ @tblName +'] where

' + @strWhere + ' ' + @strOrder

else

set @strSQL = 'select top ' + str(@PageSize) +' + ' from ['+ @tblName +'] '+

@strOrder

--��ǵ�һҳ��ִ��ϴ��룬��ӿ�ִ��ٶ�

end

else

begin

--��´��븳��@strSQL��ִ�е�SQL��

set @strSQL = 'select top ' + str(@PageSize) +' + ' from [' + @tblName +'] where ['

+ @fldName + ']' + @strTmp + '(['+ @fldName + '])

from (select top ' + str((@PageIndex-1)*@PageSize) + ' ['+ @fldName + '] from ['+ @tblName +']' +

@strOrder + ') as tblTmp)'+ @strOrder

if @strWhere != ''

set @strSQL = 'select top ' + str(@PageSize) +' + ' from ['+ @tblName +'] where

[' + @fldName + ']' + @strTmp + '(['+ @fldName + ']) from (select top ' + str((@PageIndex-1)

*@PageSize) + ' ['+ @fldName + '] from ['+ @tblName +'] where ' + @strWhere + ' ' + @strOrder + ')

as tblTmp) and ' + @strWhere + ' ' + @strOrder

end

exec ( @strSQL)

Ϊ��ʹ��洢��̣��һ��ר�ŵ��PageHelper.cs�Ĵ��嵥��

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Microsoft.Practices.EnterpriseLibrary.Data;

using System.Data.Common;

///

/// �ṩͨ�õķ�ҳ��

///

public class PagerHelper

{

public PagerHelper(string tblname, string sortname, bool docount)

{

this.tblName = tblname;

this.fldName = sortname;

this.docount = docount;

}

///

/// ��ȡ��¼��Ĺ��캯��

///

public PagerHelper(string tblname, bool docount, string strGetFields, string fldName, int

pagesize,int pageindex, bool ordertype, string strwhere)

{

this.tblName = tblname;

this.docount = docount;

this.strGetFields = strGetFields;

this.fldName = fldName;

this.pagesize = pagesize;

this.pageindex = pageindex;

this.ordertype = ordertype;

this.strwhere = strwhere;

}

/**/

///

/// �õ��Ĺ��캯��

///

/// ��

/// ��ѯ��

public PagerHelper(string tblname, string strwhere)

{

this.tblName = tblname;

this.strwhere = strwhere;

this.docount = true;

}

public PagerHelper()

{

}

private string tblName;

public string TblName

{

get { return tblName; }

set { tblName = value; }

}

private string strGetFields = "*";

public string StrGetFields

{

get { return strGetFields; }

set { strGetFields = value; }

}

//��ֶ��

private string fldName = string.Empty;

public string FldName

{

get { return fldName; }

set { fldName = value; }

}

private int pagesize = 10;

public int PageSize

{

get { return pagesize; }

set { pagesize = value; }

}

private int pageindex = 1;

public int PageIndex

{

get { return pageindex; }

set { pageindex = value; }

}

private bool docount = false;

public bool DoCount

{

get { return docount; }

set { docount = value; }

}

private bool ordertype = false;

public bool OrderType

{

get { return ordertype; }

set { ordertype = value; }

}

private string strwhere = string.Empty;

public string StrWhere

{

get { return strwhere; }

set { strwhere = value; }

}

///

/// ��ȡһ��DataReader

///

/// IDataReader

public IDataReader GetDataReader()

{

if (this.docount)

{

throw new ArgumentException("Ҫ��ؼ�¼��DoCount��һ��Ϊfalse");

}

// System.Web.HttpContext.Current.Response.Write(pageindex);

Database db = DatabaseFactory.CreateDatabase();

DbCommand comm = db.GetStoredProcCommand("Pagination");

db.AddInParameter(comm, "@tblName", DbType.String, this.tblName);

db.AddInParameter(comm, "@strGetFields", DbType.String, this.strGetFields);

db.AddInParameter(comm, "@fldName", DbType.String, this.fldName);

db.AddInParameter(comm, "@PageSize", DbType.Int32, this.pagesize);

db.AddInParameter(comm, "@PageIndex", DbType.Int32, this.pageindex);

db.AddInParameter(comm, "@doCount", DbType.Boolean, this.docount);

db.AddInParameter(comm, "@OrderType", DbType.Boolean, this.ordertype);

db.AddInParameter(comm, "@strWhere", DbType.String, this.strwhere);

return db.ExecuteReader(comm);

}

///

/// ��ȡһ��DataSet

///

/// DataSet

public DataSet GetDataSet()